Question:
Bus details based on availability
Write query to display bus_no and bus_name where the available seats are between 5 to 10 and display the records in ascending order by bus name.
Code:
bsselect5bms.sql
Select bus_no, bus_name from buses where avail_seats between 5 and 10 order by bus_name;