Write the SQL/TSQL to create the following views in the DB: 6. A view of the...

  

Transcribed Image Text:

Write the SQL/TSQL to create the following views in the DB: 6. A view of the customer table that is used solely as a mailing list (fname, Iname, street, city, state, zip) called v_customer. 7. A view that contains the hotel location (name, street, city, state, zip), phone, description of the rewards category and the number of points earned for that hotel called v_hotel. 8. A view that contains the name and email of loyalty customers called v_loyalty_cust. 9. A view that contains the hotel name, and all information about any specials that the hotel has ever offered called v_hotel_specials. 10. A view that contains the customer id, and the total number of days they have stayed in any of the hotels called v_cust_daysstayed. Write the SQL/TSQL to create the following views in the DB: 6. A view of the customer table that is used solely as a mailing list (fname, Iname, street, city, state, zip) called v_customer. 7. A view that contains the hotel location (name, street, city, state, zip), phone, description of the rewards category and the number of points earned for that hotel called v_hotel. 8. A view that contains the name and email of loyalty customers called v_loyalty_cust. 9. A view that contains the hotel name, and all information about any specials that the hotel has ever offered called v_hotel_specials. 10. A view that contains the customer id, and the total number of days they have stayed in any of the hotels called v_cust_daysstayed.