Homework Help is Here – Start Your Trial Now!
Engineering
Computer Science
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
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
See similar textbooks
icon
Related questions
Question
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 towniD Number Varchar(30) varchar(30) varchar(0) varchar0) Number Number Number varchara0) varchar(30) PK PK pointiD Number PK manageriD townname state longitude latitude name address describe Varchar(30) opentime varchar(10) closetime varchar(10) towno %23 city varchar(20) Number phone varchar(1) FK summertemp wintertemp sealevel Number Resort Guest Review PK resortio Number PK guestiD Number FKPK questD Number resortName varchar(30) varchar(30) varchar(30) + name address country email FKPK resortiD Number street varchar(30) varchar(20) dateotreview Date townname varchar(30) varchart1s0) FK townid Number varchar(30) comments starRating Number Number phone varchar(1) %23 FK managerID Booking PK bookingo FK guestid FK resortiD FK cabinio Number CabinCost Number FKPK resortD Number Number FK.PK cabiniD Number Number Cabin fromdate PK Date startdate Date FK,PK resortD Number todate Date PK enddate Date PK cabiniD Number adultCount childCount Number Number Fate Number describe varchar(30) + petcount Number cabintype varchar(10) totalcharge Number bedroomcount Number sleepcapacity Number
Transcribed Image 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 towniD Number Varchar(30) varchar(30) varchar(0) varchar0) Number Number Number varchara0) varchar(30) PK PK pointiD Number PK manageriD townname state longitude latitude name address describe Varchar(30) opentime varchar(10) closetime varchar(10) towno %23 city varchar(20) Number phone varchar(1) FK summertemp wintertemp sealevel Number Resort Guest Review PK resortio Number PK guestiD Number FKPK questD Number resortName varchar(30) varchar(30) varchar(30) + name address country email FKPK resortiD Number street varchar(30) varchar(20) dateotreview Date townname varchar(30) varchart1s0) FK townid Number varchar(30) comments starRating Number Number phone varchar(1) %23 FK managerID Booking PK bookingo FK guestid FK resortiD FK cabinio Number CabinCost Number FKPK resortD Number Number FK.PK cabiniD Number Number Cabin fromdate PK Date startdate Date FK,PK resortD Number todate Date PK enddate Date PK cabiniD Number adultCount childCount Number Number Fate Number describe varchar(30) + petcount Number cabintype varchar(10) totalcharge Number bedroomcount Number sleepcapacity Number
Expert Solution
steps

Step by step

Solved in 2 steps with 1 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Recommended textbooks for you
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
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
A Guide to SQL
Computer Science
ISBN:
9781111527273
Author:
Philip J. Pratt
Publisher:
Course Technology Ptr
SEE MORE TEXTBOOKS