Write a query to display the guest names who are from Ooty. For instance, the guest name "geeta govind" should be displayed as "Geeta Govind". Give alias name as GUESTNAME. Sort the result based on...

Extracted text: Write a query to display the guest names who are from Ooty. For instance, the guest name "geeta govind" should be displayed as "Geeta Govind". Give alias name as GUESTNAME. Sort the result based on Guest Name. Hint: Address can be in any case. Use like operator to fetch city from address. RESORT MANAGEMENT SYSTEM Town Pointofinterest Manager PK towniD Number manageriD Number PK pointiD Number PK townname state Varchar(30) varchar(30) name varchar(30) describe Varchar(30) opentime varchar(10) PC e address varchar(30) longitude latitude varchar(30) + closetime varchar(10) city varchar(20) varchar(30) phone varchar(15) summertemp wintertemp sealevel FK towniD Number Number Number Number Resort Guest Review PK resortiD Number PK questiD Number FK.PK guestiD Number resortName varchar(30) name varchar(30) FK.PK resortID Number varchar(30) + street varchar(30) MANAGES address dateofreview Date varchar(30) townname varchar(20) varchar(30) sobs country email varchar(150) FK townid Number comments phone varchar(15) starRating Number FK managerlD Number Booking PK bookinglD Number CabinCost FK guestid Number FK.PK resortiD Number FK resortiD Number cabiniD Number FKPK cabiniD Number FK Cabin fromdate PK startdate Date Date FK,PK resortID Number todate IDate enddate PK Date PK cabiniD Number adultCount Number rate Number childCount Number describe varchar(30) + petcount Number cabintype varchar(10) totalcharge Number bedroomcount Number sleepcapacity Number