Use a subquery to write an SQL statement that will list the FirstName,LastName and Phone of customers who made a purchase (Sale Subtotal) of at least $500. Each customer should be listed only once

Write a SQL statement that will list the Employee FirstName, LastName, Phone, SaleDate, and Subtotal for Employees who have initiated sale subtotals of $3000 and above.

Write an SQL statement that will list the ItemId, ItemDescription, ItemPrice, CompanyName of vendor of item with ItemID.

Write an SQL statement that will list the Customer LastName, FirstName, Phone with two additional columns- the total number of sales as NumberSalesTranscations and total sum of sales as TotalSalesAmount

Write an SQL statement that will list the ItemID and ItemDescription of items that have not had a sale transaction. In other words items that do not appear in the Sale_Item table