Display Types of Rooms available in Resorts in SQL

Question:

Display Types of Rooms available in Resorts

Resort manager wants to know the type of rooms available in the resorts. Write a query to display the resort id, number of bed rooms, and type of rooms available in resort ids 1001 and 1002. Display the result set in the ascending order of resort id, number of bed rooms and types of rooms available.

Quiz for Exam - Display Types of Rooms available in Resorts

Code:

Main.sql

select resortID, bedroomcount, cabintype 
from cabin 
where resortID=1001 or resortID=1002 
order by resortID, bedroomcount, cabintype;

Recommended:

Leave a Comment

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