Bus details based on availability in SQL

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.

Quiz for Exam - Bus details based on availability

Code:

bsselect5bms.sql

Select bus_no, bus_name from buses where avail_seats between 5 and 10 order by bus_name;

Recommended:

Leave a Comment

Your email address will not be published. Required fields are marked *

x