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';