Create a view named RESERVATION_CUSTOMER. It consists of the reservation ID, trip ID, trip date, customer number, customer last name, customer first name, and phone number. Write and execute the command to retrieve the reservation ID, trip ID, trip date, and customer last name for every reservation in the RESERVATION_CUSTOMER view with a trip date of September 11 , 2016.   WHAT AM I MISSING OR HAVE INCORRECT ? SELECT Reservation_ID, Trip_ID, Trip_Date, Last_Name FROM RESERVATION_CUSTOMER WHERE TRIP_DATE = '09-SEP-2016';

A Guide to SQL
9th Edition
ISBN:9781111527273
Author:Philip J. Pratt
Publisher:Philip J. Pratt
Chapter7: Database Administration
Section: Chapter Questions
Problem 2SCG: Create a view named CONDO_OWNERS. It consists of the location number, unit number, square footage,...
icon
Related questions
icon
Concept explainers
Question

Create a view named RESERVATION_CUSTOMER. It consists of the reservation ID, trip
ID, trip date, customer number, customer last name, customer first name, and phone
number.

Write and execute the command to retrieve the reservation ID, trip ID, trip date, and
customer last name for every reservation in the RESERVATION_CUSTOMER view
with a trip date of September 11 , 2016.

 

WHAT AM I MISSING OR HAVE INCORRECT ?

SELECT Reservation_ID, Trip_ID, Trip_Date, Last_Name

FROM RESERVATION_CUSTOMER

WHERE TRIP_DATE = '09-SEP-2016';

 

 

Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 1 images

Blurred answer
Knowledge Booster
Query Syntax
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
A Guide to SQL
A Guide to SQL
Computer Science
ISBN:
9781111527273
Author:
Philip J. Pratt
Publisher:
Course Technology Ptr
Oracle 12c: SQL
Oracle 12c: SQL
Computer Science
ISBN:
9781305251038
Author:
Joan Casteel
Publisher:
Cengage Learning