Question

write a SQL query to display number of buses that reach each destination.Order the result by Destination in desc order​

Answer 1

Answer:

select no of buses from (table name) order by destination desc;

Explanation:

Answer 2

Answer:

Explanation:

In order to get the data, I am building a SQL query.

the bus no option

through bus info

bus no in order

Due to the lack of field names in this instance, all the fields, including bus no, are fictitious. Because the table names are not provided, further assumptions are made.

All necessary columns will be carried by "select" when it is used.

The table name from which data must be retrieved will be contained in the "from clause."

The data is sorted using a "order by clause" in one of two ways: ascending or descending.

SQL Query:

A database table or group of tables may be requested for data or information via a query. Structured Query Language (SQL) results or complicated results, such as trend analyses from data-mining technologies, may be used to generate this data as illustrations, graphs, or other types of complex results.

#SPJ5