Resort with Least Capacity
Write to query to display the name and town name of the resort that has least bed room count. Sort the output on the resort name.
SQL Code: Resort with Least Capacity Solution
select rs.resortname, rs.townname
from resort rs left join cabin c
on rs.resortid = c.resortid
where c.bedroomcount = (select min(bedroomcount) from cabin)
order by 1;Related:
- Review Comments Shared by Guest in SQL
- Maximum amount paid by Guest in SQL
- pointofinterest locations in each Town in SQL
- Payments made by Guest in SQL
- Fetch Resort Details in SQL
- Review Comment for all Resort in SQL
- Review Comment for star rating Resort in SQL
- Resort that charges the highest in SQL
- Cities having Summer Temperature More than Jaipur in SQL
- PointOfInterest Locations in Chennai in SQL
- Guest who paid highest charges in SQL
- Guest details and Total Charges paid in SQL
- Create View_BMS in SQL
