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.

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:
- 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
- Cities having Summer Temperature More than Jaipur in SQL
- PointOfInterest Locations in Chennai in SQL
- Resort with Least Capacity in SQL
- Guest who paid highest charges in SQL
- Guest details and Total Charges paid in SQL
- Create View_BMS in SQL