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 PK manageriD Number townname varchar(30) varchar(30) describe Varchar(30) name state opentime varchar(10) address longitude varchar(30) closetime varchar(10) city varchar(20) varchar(30) Number Number latitude towniD Number phone varchar(15) FK summertemp wintertemp sealevel Number GIVES Resort Guest Review PK resortiD Number PK guestiD Number FK,PK guestlID Number resortName varchar(30) name varchar(30) FK.PK resortID Number street varchar(30) MANAGES address varchar(30) + dateofreview Date varchar(30) townname varchar(20) varchar(30) country BOOKS email comments varchar(150) FK townid Number phone varchar(15) starRating Number FK manageriD Number Booking HAS PK bookingID Number CabinCost FK guestid Number HAS FK,PK resortiD Number FK resortID Number FK,PK cabiniD Number FK cabiniD Number Cabin fromdate Date PK startdate Date FK,PK resortID Number todate Date PK enddate Date cabiniD Number PK adultCount Number rate Number childCount Number describe varchar(30) +H Number petcount cabintype varchar(10) totalcharge Number bedroomcount Number sleepcapacity Number