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 Pointofinterest Town Manager Number Varchar(30) PK townID managerID PK pointID Number PK Number townname varchar(30) describe Varchar(30) name opentime varchar(10) PC 王 state longitude latitude varchar(30) varchar(30) varchar(30) address varchar(30) %3 closetime varchar(10) city varchar(20) HAS phone varchar(15) summertemp wintertemp sealevel FK townID Number Number Number Number Resort Guest Review PK resortID Number guestID Number PK FK,PK guestiD Number varchar(30) resortName varchar(30) name FK.PK resortID Number street varchar(30) MANADES address varchar(30) + dateofreview Date townname varchar(30) country varchar(20) BOOKS FK townid Number email varchar(30) comments varchar(150) phone varchar(15) starRating Number FK managerID Number Booking HAS PK bookingID Number CabinCost HAS 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 Number todate Date HAS PK enddate Date HAS PK cabiniD Number adultCount Number rate Number childCount Number describe varchar(30) HP petcount totalcharge Number cabintype varchar(10) Number bedroomcount Number sleepcapacity Number