Complete and print the following SQL transactions. Log your statements and results by spooling your file (with echo on from Oracle if available).

List reservation number, check-in date, check-out date, and the total number of rooms reserved for each reservation. Use the following column headings: ResNum, CheckIn, CheckOut, RoomCount. Hint: Use a GROUP BY clause.

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