Question:
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.
Code:
Main.sql
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;