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;