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.
select rs.resortname, c.describe, c.cabintype, c.bedroomcount from resort rs join cabin c on c.resortid=rs.resortid order by rs.resortid;