27. Complete and print your statements and results by spooling your file (with e

Question

27.          Complete and print your statements and results by spooling your file (with echo on from Oracle if available).

List the ResNum, CheckInDate, CheckOutDate, CustID, CustLName, AgentID, and AgentLName for all reservations on or before 2/28/18. Sort by CheckInDate, then by ResNum, both in ascending order.

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 AgentTypeDesc

Explanation / Answer

SELECT R.ResID as ResNum, R.CheckInDate as CheckInDate, R.CheckOutDate as CheckOutDate,

C.CustID as CustID, C.CustLName as CustLName, R.AgentID as AgentID, A.AgentLName as AgentLName

FROM Customer C, Reservation R, Agent A

WHERE C.CustID = R.CustID AND R.AgentID = A.AgentID

AND R.CheckInDate <= '2/28/18'

ORDER BY R.CheckInDate, R.ResID;

Related Questions

Navigate

• Browse (All)
• Browse 2
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.