For the below given schema diagram develop a SQL query to find the guest name whose total bill amount is more than 50,000. RESORT MANAGEMENT SYSTEM Town Pointofinterest Manager Number Varchar(30)...

wevsv

Extracted text: For the below given schema diagram develop a SQL query to find the guest name whose total bill amount is more than 50,000. RESORT MANAGEMENT SYSTEM Town Pointofinterest Manager Number Varchar(30) varchar(30) varchar(30) Number PK townlD Number PK pointiD PK managerlD townname varchar(30) varchar(30) varchar(20) varchar(15) describe Varchar(30) name state address opentime varchar(10) 主 longitude closetime varchar(10) city latitude varchar(30) Number phone FK townID summertemp Number wintertemp Number sealevel Number GIVES Resort Guest Review PK resortID Number PK guestiD Number FK,PK guestiD FK,PK resortiD Number Number varchar(30) varchar(30) varchar(30) resortName varchar(30) varchar(30) + varchar(20) varchar(30) varchar(15) name street MANACES address dateofreview Date townname country BOOKS varchar(150) Number email comments FK townid phone 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 PK startdate Date Date todate FK,PK resortID HAS Number enddate Date PK Date HAS PK cabinID Number adultCount Number rate Number varchar(30) + varchar(10) childCount Number describe petcount Number cabintype totalcharge Number bedroomcount Number sleepcapacity Number