Resort that charges the highest in SQL

Resort that charges the highest

Write a query to display the name of the resort that charges the highest. Sort the output on the resort name.

Resort that charges the highest
Resort that charges the highest

select r.resortname
from resort r join cabincost c
on c.resortid=r.resortid
where c.rate=(select max(rate) from cabincost)
order by 1;

Related:

Leave a Comment

four + 15 =