SQL

Adventure Tours database is shown below. You need to archive all Reservations if trips occurred before Jan-1, 2016.

Similarly, if a Customer's last Reservation occurred before Jan-1, 2016 , archive them as well. Assume the Trips and Guides remain current, and don't need archiving.

Guide (GuideNum, LastName, Firstname)

Trip (TripID, TripName, Location, State, Type, Season)

Customer (CustomerNum, CustomerName)

Reservation (ReservationID, TripID, TripDate, NumPersons, TripPrice, CustomerNum)

TripGuides (TripID, GuideNum)

Questions:

1. Create a view that will be used to archive Reservation table

2. Create a view that will be used to archive Customer table