Details about AC Buses in SQL

Question:

Display bus_no as bus_number and bus_name as bus_name which has minimum 10 available seats and bus type is ‘ac’ and display it in ascending order by bus_no.

Code:

Main.sql

select bus_no as bus_number, bus_name as bus_name
from buses
where avail_seats >= 10 and type = 'ac'
order by bus_no;

Recommended: