Write an SQL statement to create a view named CustomerSalesView based on the the CUSTOMER_04 and SALE_02 tables. In this view, include the values of Customer ID, LastName as CustomerLastName, FirstName as CustomerFirstName, EmailAddress, SaleID, DateOfSale, and SaleAmount in that order. Run this statement to create the view, and then test the view by writing and running an appropriate SQL SELECT statement.