Reference no: EM131695787
Query 1- Create SQL query that shows the CustomerID, EmployeeID, and SaleDate for all sales made on and after 1/1/2014
Query 2- Create 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-Create SQL query that shows all customer information for customers in the cities - Redmond, Bellevue or Seattle.
Query 4-Create SQL query that shows ItemID and ItemDescription for items that have an item cost between $500 and $1000.
Query 5-Create SQL query that shows the SaleId and the total ItemPrice for each sales ID in the SALE_ITEM table
Query 6-Create SQL subquery that shows the CustomerLastname, CustomerFirstname, Email for customers who have made a SALE Subtotal of $10,000 and above..
Query 7-Create 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