Teomdate 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 Town Pointofinterest PK pointID Number describe Varchar(30) opentime varchar(10) L Manager PK towniD Number manageriD Number varchar(30) PK Varchar(30) varchar(30) varchar(30) varchar(30) townname Iname state address varchar(30) longitude closetime varchar(10) latitude city varchar(20) phone varchar(15) summertemp wintertemp FK towniD Number Number Number sealevel Number Resort Guest Review PK resortID Number questiD Number PK FK.PK questID Number resortName varchar(30) name varchar(30) FKPK resortiD Number varchar(30) street varchar(30) H obs address dateofreview Date townname varchar(30) country varchar(20) email varchar(30) varchar(150) FK townid Number comments phone varchar(15) %23 starRating Number FK managertD Number Booking PK bookingiD Number CabinCost FK guestid Number 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 PK cabiniD Number adultCount Tchildcount Number Number rate Number describe varchar(30) petcount Number cabintype varchar(10) totalcharge Number bedroomcount Number || || |||