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)...

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) PK townID PK managerID Number PK pointID Number townname varchar(30) varchar(30) varchar(20) | varchar(15) describe Varchar(30) name state address opentime varchar(10) closetime varchar(10) %23 longitude city latitude varchar(30) FK townID Number HAS phone summertemp Number wintertemp Number sealevel Number GIVES Resort Guest Review Number varchar(30) varchar(30) varchar(30) PK resortiD guestiD Number PK FK,PK guestiD FK,PK resortiD Number Number resortName varchar(30) varchar(30) + varchar(20) varchar(30) varchar(15) name street MANAGES address dateofreview Date townname country BOOKS varchar(150) FK townid Number email comments phone starRating Number FK manageriD Number Booking HAS РК 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 FK,PK resortiD HAS Number todate Date PK enddate 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