Write a query to display the guest names who are from Ooty. For instance, the guest name "geeta govind" should be displayed a "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 Manager managero Pointofinterest Number Varchar0) varchar) varchar() + varchar() Number Number Number PK towniD townname Number PK pointio Number describe Varcharp0) opentime varcharn0) closetime varchar10) PK varchar0) varchar0) varchar20) varchart1) name state address longitude latitude city FK towno Number phone summertemp wintertemp sealevel Resort Guest Review PK resorto Number PK guestib Number FKPK guestD Number varchar(0) varchar(30) varchar(0) resortName varchar() address varchar(30) + varchar(2) name FKPK resortiD Number street s dateotreview Date townname country email varchar(0) varchar(10) FK townid Number comments starRating K manageriD Number Number phone varchar() Booking Number PK bookingo FK questid CabinCost Number FKPK resoro Number FK resortiD Number FKPK cabinio Number FK cabino fromdate Number Cabin PK startdate Date Date FKPK resorto Number todate Date PK enddate Date adutCount PK cabinio Number Number Fate Number childCount describe varchar(30) + Number petcount Number cabintype varchar(10) totalcharge Number bedroomcount Number sleepcapacity Number
Write a query to display the guest names who are from Ooty. For instance, the guest name "geeta govind" should be displayed a "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 Manager managero Pointofinterest Number Varchar0) varchar) varchar() + varchar() Number Number Number PK towniD townname Number PK pointio Number describe Varcharp0) opentime varcharn0) closetime varchar10) PK varchar0) varchar0) varchar20) varchart1) name state address longitude latitude city FK towno Number phone summertemp wintertemp sealevel Resort Guest Review PK resorto Number PK guestib Number FKPK guestD Number varchar(0) varchar(30) varchar(0) resortName varchar() address varchar(30) + varchar(2) name FKPK resortiD Number street s dateotreview Date townname country email varchar(0) varchar(10) FK townid Number comments starRating K manageriD Number Number phone varchar() Booking Number PK bookingo FK questid CabinCost Number FKPK resoro Number FK resortiD Number FKPK cabinio Number FK cabino fromdate Number Cabin PK startdate Date Date FKPK resorto Number todate Date PK enddate Date adutCount PK cabinio Number Number Fate Number childCount describe varchar(30) + Number petcount Number cabintype varchar(10) totalcharge Number bedroomcount Number sleepcapacity Number
Database Systems: Design, Implementation, & Management
12th Edition
ISBN:9781305627482
Author:Carlos Coronel, Steven Morris
Publisher:Carlos Coronel, Steven Morris
Chapter8: Advanced Sql
Section: Chapter Questions
Problem 55P
Related questions
Question
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps with 1 images
Recommended textbooks for you
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781285196145
Author:
Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:
Cengage Learning
A Guide to SQL
Computer Science
ISBN:
9781111527273
Author:
Philip J. Pratt
Publisher:
Course Technology Ptr
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781285196145
Author:
Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:
Cengage Learning
A Guide to SQL
Computer Science
ISBN:
9781111527273
Author:
Philip J. Pratt
Publisher:
Course Technology Ptr