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 towniD Number Varchar(30) varchar(30) varchar(30) varchar(30) PK manageriD Number PK PK pointiD Number townname describe Varchar(30) name varchar(30) state opentime varchar(10) address varchar(30) %23 longitude varchar(20) varchar(15) closetime varchar(10) city latitude towniD Number summertemp Number HAS phone FK wintertemp sealevel Number Number Resort Guest Review PK resortiD Number PK guestiD Number FK,PK guestID Number resortName varchar(30) Iname varchar(30) FK,PK resortiD Number street varchar(30) MANACES varchar(30) + varchar(20) address dateofreview Date townname varchar(30) country townid Number EK email varchar(30) comments varchar(150) phone varchar(15) %23 starRating Number FK manageriD Number Reokie Booking HAS PK bookingID Number CabinCost FK guestid Number HAs FK.PK resortiD Number FK resortlID Number FK.PK cabiniD Number FK cabiniD Number Cabin Date PK startdate Date fromidate FK.PK resortID Number todate Date PK enddate Date adultCount Number PK cabiniD Number rate Number childCount Number describe varchar(30) petcount Number cabintype varchar(10) totalcharge Number bedroomcount Number sleepcapacity Number ||| | |||