Based on the three tables and the attributes below, write SQL commands for each question to retrieve the data from the database. 00 Inventory * InventoryID Name BeverageType Caffeinated Flavored Purchase Price Salesitems * InvoiceID 8 InventoryID Quantity UnitPrice Sales 8 InvoiceID InvoiceDate OrderDate CustomerID EmployeeID CustomerPo Required: a. What are the foreign keys in the Sales table? b. How many sales transactions were made in March, 2017? c. Which sales transactions were made by the employee whose ID is S2038' in the system? d. List the inventory items with purchase price larger than $6,500. e. Write a query to find out the dollar amount of each sales transaction. Required A Required B Required C Required D Required E What are the foreign keys in the Sales table? (Select "Yes" if the attribute is a foreign key in the Sales table, and "No" if it is not a foreign key.) InvoicelD InvoiceDate OrderDate CustomerID Employeeld CustomerPO Required A Required B Required C Required D Required E How many sales transactions were made in March, 2017? SELECT COUNT FROM WHERE BETWEEN #3/1/2017# AND #3/31/2017# Which sales transactions were made by the employee whose ID is 'S2038' in the system? SELECT FROM WHERE 'S2038' Write a query to find out the dollar amount of each sales transaction. SELECT SUM ([Quantity] * 1) AS Amount FROM WHERE Sales GROUP BY