Cabin Type and Bedroom Count in each Resort in SQL

Question:

Cabin Type and Bedroom Count in each Resort

Manager wants to know the cabin types and no of bedrooms in the resorts.  Write a query to display  resort name, description, cabin type, bed room count  available in resort. Sort the output in the order of resortid.

Cabin Type and Bedroom Count in each Resort

Code:

Main.sql

select rs.resortname, c.describe, c.cabintype, c.bedroomcount
from resort rs join cabin c
       on c.resortid=rs.resortid
order by rs.resortid;

Recommended:

Leave a Comment

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