33. Complete and print your statements and results by spooling your file (with e
ID: 3708228 • Letter: 3
Question
33. Complete and print your statements and results by spooling your file (with echo on from Oracle if available).
List the customer ID, first name, and last name for any customers who do not have any reservations. Use the following column headings: CustID, FirstName, LastName. Hint: use a Nested Select.
ResDetail Customer CustlD CustFName CustLName CustPhone CustType LoyaltylD Reservation ResID CheckinDate CheckOutDate CustID AgentID ReslD Room CustType CustType CustTypeDesc RoomNum RateType RateAmt RoomType Agent AgentlD AgentFName AgentLName AgentType RateType RateType RateTypeDesc RoomType RoomType RoomTypeDesc AgentType AgentType AgentTypeDescExplanation / Answer
SELECT CustID, C.CustFName, C.CustFName
FROM Customer
WHERE C.CustID NOT IN (SELECT CustID FROM Reservation);