Guest details and Total Charges paid Develop a simple SQL query Display guest details who paid total charges RS.50000 and above. Write a query to fetch Guest id, Guest name and Sum of total charges. Give alias name to total charges as TOTALPAID. Sort the result by guest id. RESORT MANAGEMENT SYSTEM Pointonterest Town Manager PK towniD Number manageriD name pointiD Number PK Number PK townname Varchar(30) varchar(30) H+ varchar(30) Number varchar(30) varchar(30) describe Varchar(30) state address opentime varchar(10) longitude latitude varchar(30) closetime varchar(10) city varchar(20) towniD phone varchar(1) FK Number summertemp wintertemp Number sealevel Number Resort Guest Review PK resortID Number PK Number EK.PK guestID Number varchar(30) varchar(30) resortName varchar(30) varchar(30) + name FK,PK resortiD Number street address dateofreview Date varchar(30) townname country varchar(20) comments varchar(150) FK townid Number email varchar(30) starRating Number Number phone varchar(15) %23 FK manageriD Booking PK bookingiD FK guestid Number CabinCost Number FK.PK resortiD Number FK resortiD Number FK.PK cabiniD Number FK cabiniD Number Cabin fromdate PK startdate Date Date FKPK resortiD Number todate Date PK enddate Date PK cabiniD Number adultCount Number rate Number childCount petcount totalcharge describe varchar(0) Number Number cabintype varchar(10) Number bedroomcount Number sleepcapacity Number