Resort that charges the highest You have to only develop a SQL query Write a query to display the resort name, rate of all the resorts that charges the highest. Sort the output on the resort name....

Extracted text: Resort that charges the highest You have to only develop a SQL query Write a query to display the resort name, rate of all the resorts that charges the highest. Sort the output on the resort name. Use:Resort,cabincost table) RESORT MANAGEMENT SYSTEM Town Pointofinterest Manager Number | Varchar(30) varchar(30) PK pointiD Number PK townID manageriD Number PK describe Varchar(30) townname name varchar(30) state address varchar(30) opentime varchar(10) longitude latitude varchar(30) varchar(30) Number closetime varchar(10) city varchar(20) FK townID Number phone varchar(15) summertemp wintertemp Number sealevel Number -GIVES Resort Guest Review PK resortiD Number PK guestiD Number Number Number dateofreview Date FK,PK guestlID resortName varchar(30) name varchar(30) FK.PK resortID street varchar(30) MANAGES address varchar(30) + townname varchar(30) varchar(20) varchar(30) country BOOKS email comments varchar(150) FK townid Number phone varchar(15) starRating Number FK managerlD Number Booking HAS PK bookingID Number CabinCost FK guestid Number HAS FK,PK resortiD Number FK resortiD Number FK,PK Number cabiniD FK cabiniD Number Cabin fromdate PK startdate Date Date FK,PK resortiD Number todate Date PK enddate Date cabiniD Number HAS PK adultCount Number rate Number childCount Number describe varchar(30) HE Number petcount cabintype varchar(10) totalcharge Number bedroomcount Number sleepcapacity Number