In this homework, you will work to run scripts in MySQL and write SQL Statements to answer the questions below. You will upload the MySQL file that contains the queries you write. Please follow the directions in order.

Query 1- Write an SQL query that shows the CustomerID, EmployeeID, and SaleDate for all sales made on and after 1/1/2014

Query 2- Write an SQL query that shows the ItemID, ItemDescription and PurchaseDate for Items that have an item cost of $500 and above and supplied by VendorID 9.

Query 3-Write an SQL query that shows all customer information for customers in the cities Redmond, Bellevue or Seattle.

Query 4Write an SQL query that shows ItemID and ItemDescription for items that have an item cost between $500 and $1000.

Query 5Write an SQL query that shows the SaleId and the total ItemPrice for each sales ID in the SALE_ITEM table

Query 6Write an SQL subquery that shows the CustomerLastname, CustomerFirstname, Email for customers who have made a SALE Subtotal of $10,000 and above..

Query 7Write an SQL query that shows the EmployeeID, EmployeeLastName, EmployeeFirstname, Employee Phone, CustomerId, SaleDate and Total. Please ensure to have the results sorted in ascending order by Employee Lastname