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 in SQL
Resort that charges the highest in SQL

SQL Code: Resort that charges the highest Solution

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

5 − two =