1. Create a view named WEST_COAST_CUSTOMERS_Vthat consists of all the data for customers that live in Los Angeles and San Diego. Display all the customers using this view. 2. Construct a view called WEST COAST_EMPLOYEES_V that consists of the employees first name, last name, job and hire date and the West Coast Sales departmentnumber and name theywork for.(there are two sales departments;one for the East Coast and one for the West Coast). This view will only reference the West Coast sales department. You will need to use a Join. Display the data using the WEST_COAST_EMPLOYEES_V view to show only the employee names and the West Coast Sales department name 3. Create a view named ORDERS_SHIPPED_Vthat lists all the columns in the ORD table for orders that have shipped. Use the WITH CHECK OPTION. Then attemptto add a record to this view that has shipped. Display your results.Then attemptto add a record to this view that has NOT shipped. Show your results. You wantto see a "Check Option Failed" message. 4. Create a view named ORDERS NOT SHIPPED DAYS WAITING Vthat lists the customer id order date, order id and the number of days it has been waiting to be shipped in the ORD table for orders that have NOT been shipped yet. Use the NOW function for the current date along with the order date in the DATEDIFF function to calculate the days it has been waiting to be shipped. Namethis four column Days_Waiting_To_Ship. 5. Display the data from the ORDERS NOT_SHIPPED_DAYS_WAITING Vview for orders that have not shipped between 30 and 60 days. Emp Dept PK EmpNo PK Deptno LName Dname Fname Job Customer HireDate PK CustID Sal LName Comm FName FK De ptno Street Ord City PK Ordid StateZip OrderDate Phone FK CustID FK RepID ShipDate Total Item PK Ordid Product PK ItemID PK Prodid FK ProdID Descrip QTY ProdPrice Item Tot