Guest details and Total Charges paid 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...

Extracted text: Guest details and Total Charges paid 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 Pointofinterest Town Manager PK towniD Number manageriD Number PK pointiD Number PK townname Varchar(30) describe Varchar(30) name varchar(30) varchar(30) varchar(30) + varchar(30) state opentime varchar(10) PC address varchar(30) longitude varchar(20) varchar(15) closetime varchar(10) latitude city phone FK townID Number summertemp Number wintertemp Number sealevel Number Resort Guest Review PK resortiD Number gasanb Number varchar(30) PK guestiD FK.PK guestID Number resortName varchar(30) name FK.PK resortiD Number street varchar(30) address varchar(30) + dateofreview Date townname varchar(30) varchar(20) varchar(30) country email comments varchar(150) FK townid Number Number Number phone varchar(15) starRating FK manageriD Booking PK bookinglD Number CabinCost FK guestid FK resortiD Number His FK,PK resortiD Number Number FK,PK cabiniD Number FK cabiniD Number Cabin tremdate Date PK startdate Date FKPK resortID Number todate PK enddate Date Date adultCount Number PK cabinlD Number rate Number childCount Number describe varchar(30) petcount Number cabintype varchar(10) totalcharge Number bedroomcount Number sleepcapacity Number