Question: Based on the three tables and the attributes below, write SQL commands for each question to retrieve the data from the database. Inventory InventoryID Name

Based on the three tables and the attributes below, write SQL commands for each question to retrieve the data from the database. Inventory InventoryID Name BeverageType Caffeinated Flavored PurchasePrice SalesItems InvoiceID InventoryID Quantity UnitPrice Sales 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. Complete this question by entering your answers in the tabs below. Required A Required B Required C Required D Required E Write a query to find out the dollar amount of each sales transaction. SELECT FROM WHERE Sales GROUP BY SUM ([Quantity]* ]) AS Amount < Required D Required E

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!