5. Consider the following OLAP model: The dimensional model shown here captures a row each time contact with a customer occurs. Dimensions represent the date and time of each contact, the customer contacted, and the type of communication (e.g. inbound phone call, outbound phone call, robo-call and email campaign). Date (day_key, date, month, year, holiday_season) CONTACT FACTS Customer (customer_key, customer_name, address) TIME day_key time_key customer_key contact_type_key Contact_Type (Contact_Type_Key, ContactType) CUSTOMER CONTACT TYPE Write SQL queries for each of the following: 1. List of the customer names and the number of times they were contacted. (5 points) 2. How many customers were contacted by outbound phone calls (Type 2)? (5 points) 3. How many times was customer "John Smith" contacted in Christmas 2014? (5 points) 4. How many times was customer "John Smith" contacted in Christmas 2014 by outbound phone calls (Type 2)