Based on the three tables and the attributes below, answer the question for Requirement A and...
Fantastic news! We've Found the answer you've been seeking!
Transcribed Image Text:
Based on the three tables and the attributes below, answer the question for Requirement A and write SQL commands for Requirements B to E to retrieve the data from the database. Salesltems Sales Inventory V InventoryID V InvoicelD 8 InventoryID 8 InvoicelD Name InvoiceDate OrderDate Quantity UnitPrice BeverageType Caffeinated CustomerID Flavored EmployeelD PurchasePrice 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. 81 Complete this question by entering your answers in the tabs below. Required A Required B Required C Required D Required E Required B What are the foreign keys in the Sales table? (Indicate your answers by selecting an "X" next to the applicable amounts.) 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 InvoicelD FROM Sales WHERE InvoiceDate BETWEEN #3/1/2017# AND #3/31/2017# Required A Required B Required C Required D Required E Which sales transactions were made by the employee whose ID is 'S203 SELECT FROM Sales WHERE EmployeelD 'S2038' Required A Required B Required C Required D Required E List the inventory items with purchase price larger than $6,500. SELECT InvoicelD InvoiceDate FROM Sales WHERE PurchasePrice > 6500 Required A Required B Required C Required D Required E Write a query to find out the dollar amount of each sales transaction. SELECT SUM ([Quantity] * ]) AS Amount FROM WHERE Sales GROUP BY Based on the three tables and the attributes below, answer the question for Requirement A and write SQL commands for Requirements B to E to retrieve the data from the database. Salesltems Sales Inventory V InventoryID V InvoicelD 8 InventoryID 8 InvoicelD Name InvoiceDate OrderDate Quantity UnitPrice BeverageType Caffeinated CustomerID Flavored EmployeelD PurchasePrice 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. 81 Complete this question by entering your answers in the tabs below. Required A Required B Required C Required D Required E Required B What are the foreign keys in the Sales table? (Indicate your answers by selecting an "X" next to the applicable amounts.) 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 InvoicelD FROM Sales WHERE InvoiceDate BETWEEN #3/1/2017# AND #3/31/2017# Required A Required B Required C Required D Required E Which sales transactions were made by the employee whose ID is 'S203 SELECT FROM Sales WHERE EmployeelD 'S2038' Required A Required B Required C Required D Required E List the inventory items with purchase price larger than $6,500. SELECT InvoicelD InvoiceDate FROM Sales WHERE PurchasePrice > 6500 Required A Required B Required C Required D Required E Write a query to find out the dollar amount of each sales transaction. SELECT SUM ([Quantity] * ]) AS Amount FROM WHERE Sales GROUP BY Based on the three tables and the attributes below, answer the question for Requirement A and write SQL commands for Requirements B to E to retrieve the data from the database. Salesltems Sales Inventory V InventoryID V InvoicelD 8 InventoryID 8 InvoicelD Name InvoiceDate OrderDate Quantity UnitPrice BeverageType Caffeinated CustomerID Flavored EmployeelD PurchasePrice 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. 81 Complete this question by entering your answers in the tabs below. Required A Required B Required C Required D Required E Required B What are the foreign keys in the Sales table? (Indicate your answers by selecting an "X" next to the applicable amounts.) 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 InvoicelD FROM Sales WHERE InvoiceDate BETWEEN #3/1/2017# AND #3/31/2017# Required A Required B Required C Required D Required E Which sales transactions were made by the employee whose ID is 'S203 SELECT FROM Sales WHERE EmployeelD 'S2038' Required A Required B Required C Required D Required E List the inventory items with purchase price larger than $6,500. SELECT InvoicelD InvoiceDate FROM Sales WHERE PurchasePrice > 6500 Required A Required B Required C Required D Required E Write a query to find out the dollar amount of each sales transaction. SELECT SUM ([Quantity] * ]) AS Amount FROM WHERE Sales GROUP BY Based on the three tables and the attributes below, answer the question for Requirement A and write SQL commands for Requirements B to E to retrieve the data from the database. Salesltems Sales Inventory V InventoryID V InvoicelD 8 InventoryID 8 InvoicelD Name InvoiceDate OrderDate Quantity UnitPrice BeverageType Caffeinated CustomerID Flavored EmployeelD PurchasePrice 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. 81 Complete this question by entering your answers in the tabs below. Required A Required B Required C Required D Required E Required B What are the foreign keys in the Sales table? (Indicate your answers by selecting an "X" next to the applicable amounts.) 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 InvoicelD FROM Sales WHERE InvoiceDate BETWEEN #3/1/2017# AND #3/31/2017# Required A Required B Required C Required D Required E Which sales transactions were made by the employee whose ID is 'S203 SELECT FROM Sales WHERE EmployeelD 'S2038' Required A Required B Required C Required D Required E List the inventory items with purchase price larger than $6,500. SELECT InvoicelD InvoiceDate FROM Sales WHERE PurchasePrice > 6500 Required A Required B Required C Required D Required E Write a query to find out the dollar amount of each sales transaction. SELECT SUM ([Quantity] * ]) AS Amount FROM WHERE Sales GROUP BY Based on the three tables and the attributes below, answer the question for Requirement A and write SQL commands for Requirements B to E to retrieve the data from the database. Salesltems Sales Inventory V InventoryID V InvoicelD 8 InventoryID 8 InvoicelD Name InvoiceDate OrderDate Quantity UnitPrice BeverageType Caffeinated CustomerID Flavored EmployeelD PurchasePrice 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. 81 Complete this question by entering your answers in the tabs below. Required A Required B Required C Required D Required E Required B What are the foreign keys in the Sales table? (Indicate your answers by selecting an "X" next to the applicable amounts.) 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 InvoicelD FROM Sales WHERE InvoiceDate BETWEEN #3/1/2017# AND #3/31/2017# Required A Required B Required C Required D Required E Which sales transactions were made by the employee whose ID is 'S203 SELECT FROM Sales WHERE EmployeelD 'S2038' Required A Required B Required C Required D Required E List the inventory items with purchase price larger than $6,500. SELECT InvoicelD InvoiceDate FROM Sales WHERE PurchasePrice > 6500 Required A Required B Required C Required D Required E Write a query to find out the dollar amount of each sales transaction. SELECT SUM ([Quantity] * ]) AS Amount FROM WHERE Sales GROUP BY Based on the three tables and the attributes below, answer the question for Requirement A and write SQL commands for Requirements B to E to retrieve the data from the database. Salesltems Sales Inventory V InventoryID V InvoicelD 8 InventoryID 8 InvoicelD Name InvoiceDate OrderDate Quantity UnitPrice BeverageType Caffeinated CustomerID Flavored EmployeelD PurchasePrice 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. 81 Complete this question by entering your answers in the tabs below. Required A Required B Required C Required D Required E Required B What are the foreign keys in the Sales table? (Indicate your answers by selecting an "X" next to the applicable amounts.) 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 InvoicelD FROM Sales WHERE InvoiceDate BETWEEN #3/1/2017# AND #3/31/2017# Required A Required B Required C Required D Required E Which sales transactions were made by the employee whose ID is 'S203 SELECT FROM Sales WHERE EmployeelD 'S2038' Required A Required B Required C Required D Required E List the inventory items with purchase price larger than $6,500. SELECT InvoicelD InvoiceDate FROM Sales WHERE PurchasePrice > 6500 Required A Required B Required C Required D Required E Write a query to find out the dollar amount of each sales transaction. SELECT SUM ([Quantity] * ]) AS Amount FROM WHERE Sales GROUP BY Based on the three tables and the attributes below, answer the question for Requirement A and write SQL commands for Requirements B to E to retrieve the data from the database. Salesltems Sales Inventory V InventoryID V InvoicelD 8 InventoryID 8 InvoicelD Name InvoiceDate OrderDate Quantity UnitPrice BeverageType Caffeinated CustomerID Flavored EmployeelD PurchasePrice 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. 81 Complete this question by entering your answers in the tabs below. Required A Required B Required C Required D Required E Required B What are the foreign keys in the Sales table? (Indicate your answers by selecting an "X" next to the applicable amounts.) 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 InvoicelD FROM Sales WHERE InvoiceDate BETWEEN #3/1/2017# AND #3/31/2017# Required A Required B Required C Required D Required E Which sales transactions were made by the employee whose ID is 'S203 SELECT FROM Sales WHERE EmployeelD 'S2038' Required A Required B Required C Required D Required E List the inventory items with purchase price larger than $6,500. SELECT InvoicelD InvoiceDate FROM Sales WHERE PurchasePrice > 6500 Required A Required B Required C Required D Required E Write a query to find out the dollar amount of each sales transaction. SELECT SUM ([Quantity] * ]) AS Amount FROM WHERE Sales GROUP BY Based on the three tables and the attributes below, answer the question for Requirement A and write SQL commands for Requirements B to E to retrieve the data from the database. Salesltems Sales Inventory V InventoryID V InvoicelD 8 InventoryID 8 InvoicelD Name InvoiceDate OrderDate Quantity UnitPrice BeverageType Caffeinated CustomerID Flavored EmployeelD PurchasePrice 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. 81 Complete this question by entering your answers in the tabs below. Required A Required B Required C Required D Required E Required B What are the foreign keys in the Sales table? (Indicate your answers by selecting an "X" next to the applicable amounts.) 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 InvoicelD FROM Sales WHERE InvoiceDate BETWEEN #3/1/2017# AND #3/31/2017# Required A Required B Required C Required D Required E Which sales transactions were made by the employee whose ID is 'S203 SELECT FROM Sales WHERE EmployeelD 'S2038' Required A Required B Required C Required D Required E List the inventory items with purchase price larger than $6,500. SELECT InvoicelD InvoiceDate FROM Sales WHERE PurchasePrice > 6500 Required A Required B Required C Required D Required E Write a query to find out the dollar amount of each sales transaction. SELECT SUM ([Quantity] * ]) AS Amount FROM WHERE Sales GROUP BY Based on the three tables and the attributes below, answer the question for Requirement A and write SQL commands for Requirements B to E to retrieve the data from the database. Salesltems Sales Inventory V InventoryID V InvoicelD 8 InventoryID 8 InvoicelD Name InvoiceDate OrderDate Quantity UnitPrice BeverageType Caffeinated CustomerID Flavored EmployeelD PurchasePrice 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. 81 Complete this question by entering your answers in the tabs below. Required A Required B Required C Required D Required E Required B What are the foreign keys in the Sales table? (Indicate your answers by selecting an "X" next to the applicable amounts.) 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 InvoicelD FROM Sales WHERE InvoiceDate BETWEEN #3/1/2017# AND #3/31/2017# Required A Required B Required C Required D Required E Which sales transactions were made by the employee whose ID is 'S203 SELECT FROM Sales WHERE EmployeelD 'S2038' Required A Required B Required C Required D Required E List the inventory items with purchase price larger than $6,500. SELECT InvoicelD InvoiceDate FROM Sales WHERE PurchasePrice > 6500 Required A Required B Required C Required D Required E Write a query to find out the dollar amount of each sales transaction. SELECT SUM ([Quantity] * ]) AS Amount FROM WHERE Sales GROUP BY Based on the three tables and the attributes below, answer the question for Requirement A and write SQL commands for Requirements B to E to retrieve the data from the database. Salesltems Sales Inventory V InventoryID V InvoicelD 8 InventoryID 8 InvoicelD Name InvoiceDate OrderDate Quantity UnitPrice BeverageType Caffeinated CustomerID Flavored EmployeelD PurchasePrice 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. 81 Complete this question by entering your answers in the tabs below. Required A Required B Required C Required D Required E Required B What are the foreign keys in the Sales table? (Indicate your answers by selecting an "X" next to the applicable amounts.) 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 InvoicelD FROM Sales WHERE InvoiceDate BETWEEN #3/1/2017# AND #3/31/2017# Required A Required B Required C Required D Required E Which sales transactions were made by the employee whose ID is 'S203 SELECT FROM Sales WHERE EmployeelD 'S2038' Required A Required B Required C Required D Required E List the inventory items with purchase price larger than $6,500. SELECT InvoicelD InvoiceDate FROM Sales WHERE PurchasePrice > 6500 Required A Required B Required C Required D Required E Write a query to find out the dollar amount of each sales transaction. SELECT SUM ([Quantity] * ]) AS Amount FROM WHERE Sales GROUP BY Based on the three tables and the attributes below, answer the question for Requirement A and write SQL commands for Requirements B to E to retrieve the data from the database. Salesltems Sales Inventory V InventoryID V InvoicelD 8 InventoryID 8 InvoicelD Name InvoiceDate OrderDate Quantity UnitPrice BeverageType Caffeinated CustomerID Flavored EmployeelD PurchasePrice 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. 81 Complete this question by entering your answers in the tabs below. Required A Required B Required C Required D Required E Required B What are the foreign keys in the Sales table? (Indicate your answers by selecting an "X" next to the applicable amounts.) 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 InvoicelD FROM Sales WHERE InvoiceDate BETWEEN #3/1/2017# AND #3/31/2017# Required A Required B Required C Required D Required E Which sales transactions were made by the employee whose ID is 'S203 SELECT FROM Sales WHERE EmployeelD 'S2038' Required A Required B Required C Required D Required E List the inventory items with purchase price larger than $6,500. SELECT InvoicelD InvoiceDate FROM Sales WHERE PurchasePrice > 6500 Required A Required B Required C Required D Required E Write a query to find out the dollar amount of each sales transaction. SELECT SUM ([Quantity] * ]) AS Amount FROM WHERE Sales GROUP BY Based on the three tables and the attributes below, answer the question for Requirement A and write SQL commands for Requirements B to E to retrieve the data from the database. Salesltems Sales Inventory V InventoryID V InvoicelD 8 InventoryID 8 InvoicelD Name InvoiceDate OrderDate Quantity UnitPrice BeverageType Caffeinated CustomerID Flavored EmployeelD PurchasePrice 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. 81 Complete this question by entering your answers in the tabs below. Required A Required B Required C Required D Required E Required B What are the foreign keys in the Sales table? (Indicate your answers by selecting an "X" next to the applicable amounts.) 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 InvoicelD FROM Sales WHERE InvoiceDate BETWEEN #3/1/2017# AND #3/31/2017# Required A Required B Required C Required D Required E Which sales transactions were made by the employee whose ID is 'S203 SELECT FROM Sales WHERE EmployeelD 'S2038' Required A Required B Required C Required D Required E List the inventory items with purchase price larger than $6,500. SELECT InvoicelD InvoiceDate FROM Sales WHERE PurchasePrice > 6500 Required A Required B Required C Required D Required E Write a query to find out the dollar amount of each sales transaction. SELECT SUM ([Quantity] * ]) AS Amount FROM WHERE Sales GROUP BY Based on the three tables and the attributes below, answer the question for Requirement A and write SQL commands for Requirements B to E to retrieve the data from the database. Salesltems Sales Inventory V InventoryID V InvoicelD 8 InventoryID 8 InvoicelD Name InvoiceDate OrderDate Quantity UnitPrice BeverageType Caffeinated CustomerID Flavored EmployeelD PurchasePrice 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. 81 Complete this question by entering your answers in the tabs below. Required A Required B Required C Required D Required E Required B What are the foreign keys in the Sales table? (Indicate your answers by selecting an "X" next to the applicable amounts.) 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 InvoicelD FROM Sales WHERE InvoiceDate BETWEEN #3/1/2017# AND #3/31/2017# Required A Required B Required C Required D Required E Which sales transactions were made by the employee whose ID is 'S203 SELECT FROM Sales WHERE EmployeelD 'S2038' Required A Required B Required C Required D Required E List the inventory items with purchase price larger than $6,500. SELECT InvoicelD InvoiceDate FROM Sales WHERE PurchasePrice > 6500 Required A Required B Required C Required D Required E Write a query to find out the dollar amount of each sales transaction. SELECT SUM ([Quantity] * ]) AS Amount FROM WHERE Sales GROUP BY Based on the three tables and the attributes below, answer the question for Requirement A and write SQL commands for Requirements B to E to retrieve the data from the database. Salesltems Sales Inventory V InventoryID V InvoicelD 8 InventoryID 8 InvoicelD Name InvoiceDate OrderDate Quantity UnitPrice BeverageType Caffeinated CustomerID Flavored EmployeelD PurchasePrice 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. 81 Complete this question by entering your answers in the tabs below. Required A Required B Required C Required D Required E Required B What are the foreign keys in the Sales table? (Indicate your answers by selecting an "X" next to the applicable amounts.) 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 InvoicelD FROM Sales WHERE InvoiceDate BETWEEN #3/1/2017# AND #3/31/2017# Required A Required B Required C Required D Required E Which sales transactions were made by the employee whose ID is 'S203 SELECT FROM Sales WHERE EmployeelD 'S2038' Required A Required B Required C Required D Required E List the inventory items with purchase price larger than $6,500. SELECT InvoicelD InvoiceDate FROM Sales WHERE PurchasePrice > 6500 Required A Required B Required C Required D Required E Write a query to find out the dollar amount of each sales transaction. SELECT SUM ([Quantity] * ]) AS Amount FROM WHERE Sales GROUP BY Based on the three tables and the attributes below, answer the question for Requirement A and write SQL commands for Requirements B to E to retrieve the data from the database. Salesltems Sales Inventory V InventoryID V InvoicelD 8 InventoryID 8 InvoicelD Name InvoiceDate OrderDate Quantity UnitPrice BeverageType Caffeinated CustomerID Flavored EmployeelD PurchasePrice 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. 81 Complete this question by entering your answers in the tabs below. Required A Required B Required C Required D Required E Required B What are the foreign keys in the Sales table? (Indicate your answers by selecting an "X" next to the applicable amounts.) 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 InvoicelD FROM Sales WHERE InvoiceDate BETWEEN #3/1/2017# AND #3/31/2017# Required A Required B Required C Required D Required E Which sales transactions were made by the employee whose ID is 'S203 SELECT FROM Sales WHERE EmployeelD 'S2038' Required A Required B Required C Required D Required E List the inventory items with purchase price larger than $6,500. SELECT InvoicelD InvoiceDate FROM Sales WHERE PurchasePrice > 6500 Required A Required B Required C Required D Required E Write a query to find out the dollar amount of each sales transaction. SELECT SUM ([Quantity] * ]) AS Amount FROM WHERE Sales GROUP BY Based on the three tables and the attributes below, answer the question for Requirement A and write SQL commands for Requirements B to E to retrieve the data from the database. Salesltems Sales Inventory V InventoryID V InvoicelD 8 InventoryID 8 InvoicelD Name InvoiceDate OrderDate Quantity UnitPrice BeverageType Caffeinated CustomerID Flavored EmployeelD PurchasePrice 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. 81 Complete this question by entering your answers in the tabs below. Required A Required B Required C Required D Required E Required B What are the foreign keys in the Sales table? (Indicate your answers by selecting an "X" next to the applicable amounts.) 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 InvoicelD FROM Sales WHERE InvoiceDate BETWEEN #3/1/2017# AND #3/31/2017# Required A Required B Required C Required D Required E Which sales transactions were made by the employee whose ID is 'S203 SELECT FROM Sales WHERE EmployeelD 'S2038' Required A Required B Required C Required D Required E List the inventory items with purchase price larger than $6,500. SELECT InvoicelD InvoiceDate FROM Sales WHERE PurchasePrice > 6500 Required A Required B Required C Required D Required E Write a query to find out the dollar amount of each sales transaction. SELECT SUM ([Quantity] * ]) AS Amount FROM WHERE Sales GROUP BY Based on the three tables and the attributes below, answer the question for Requirement A and write SQL commands for Requirements B to E to retrieve the data from the database. Salesltems Sales Inventory V InventoryID V InvoicelD 8 InventoryID 8 InvoicelD Name InvoiceDate OrderDate Quantity UnitPrice BeverageType Caffeinated CustomerID Flavored EmployeelD PurchasePrice 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. 81 Complete this question by entering your answers in the tabs below. Required A Required B Required C Required D Required E Required B What are the foreign keys in the Sales table? (Indicate your answers by selecting an "X" next to the applicable amounts.) 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 InvoicelD FROM Sales WHERE InvoiceDate BETWEEN #3/1/2017# AND #3/31/2017# Required A Required B Required C Required D Required E Which sales transactions were made by the employee whose ID is 'S203 SELECT FROM Sales WHERE EmployeelD 'S2038' Required A Required B Required C Required D Required E List the inventory items with purchase price larger than $6,500. SELECT InvoicelD InvoiceDate FROM Sales WHERE PurchasePrice > 6500 Required A Required B Required C Required D Required E Write a query to find out the dollar amount of each sales transaction. SELECT SUM ([Quantity] * ]) AS Amount FROM WHERE Sales GROUP BY Based on the three tables and the attributes below, answer the question for Requirement A and write SQL commands for Requirements B to E to retrieve the data from the database. Salesltems Sales Inventory V InventoryID V InvoicelD 8 InventoryID 8 InvoicelD Name InvoiceDate OrderDate Quantity UnitPrice BeverageType Caffeinated CustomerID Flavored EmployeelD PurchasePrice 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. 81 Complete this question by entering your answers in the tabs below. Required A Required B Required C Required D Required E Required B What are the foreign keys in the Sales table? (Indicate your answers by selecting an "X" next to the applicable amounts.) 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 InvoicelD FROM Sales WHERE InvoiceDate BETWEEN #3/1/2017# AND #3/31/2017# Required A Required B Required C Required D Required E Which sales transactions were made by the employee whose ID is 'S203 SELECT FROM Sales WHERE EmployeelD 'S2038' Required A Required B Required C Required D Required E List the inventory items with purchase price larger than $6,500. SELECT InvoicelD InvoiceDate FROM Sales WHERE PurchasePrice > 6500 Required A Required B Required C Required D Required E Write a query to find out the dollar amount of each sales transaction. SELECT SUM ([Quantity] * ]) AS Amount FROM WHERE Sales GROUP BY Based on the three tables and the attributes below, answer the question for Requirement A and write SQL commands for Requirements B to E to retrieve the data from the database. Salesltems Sales Inventory V InventoryID V InvoicelD 8 InventoryID 8 InvoicelD Name InvoiceDate OrderDate Quantity UnitPrice BeverageType Caffeinated CustomerID Flavored EmployeelD PurchasePrice 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. 81 Complete this question by entering your answers in the tabs below. Required A Required B Required C Required D Required E Required B What are the foreign keys in the Sales table? (Indicate your answers by selecting an "X" next to the applicable amounts.) 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 InvoicelD FROM Sales WHERE InvoiceDate BETWEEN #3/1/2017# AND #3/31/2017# Required A Required B Required C Required D Required E Which sales transactions were made by the employee whose ID is 'S203 SELECT FROM Sales WHERE EmployeelD 'S2038' Required A Required B Required C Required D Required E List the inventory items with purchase price larger than $6,500. SELECT InvoicelD InvoiceDate FROM Sales WHERE PurchasePrice > 6500 Required A Required B Required C Required D Required E Write a query to find out the dollar amount of each sales transaction. SELECT SUM ([Quantity] * ]) AS Amount FROM WHERE Sales GROUP BY Based on the three tables and the attributes below, answer the question for Requirement A and write SQL commands for Requirements B to E to retrieve the data from the database. Salesltems Sales Inventory V InventoryID V InvoicelD 8 InventoryID 8 InvoicelD Name InvoiceDate OrderDate Quantity UnitPrice BeverageType Caffeinated CustomerID Flavored EmployeelD PurchasePrice 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. 81 Complete this question by entering your answers in the tabs below. Required A Required B Required C Required D Required E Required B What are the foreign keys in the Sales table? (Indicate your answers by selecting an "X" next to the applicable amounts.) 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 InvoicelD FROM Sales WHERE InvoiceDate BETWEEN #3/1/2017# AND #3/31/2017# Required A Required B Required C Required D Required E Which sales transactions were made by the employee whose ID is 'S203 SELECT FROM Sales WHERE EmployeelD 'S2038' Required A Required B Required C Required D Required E List the inventory items with purchase price larger than $6,500. SELECT InvoicelD InvoiceDate FROM Sales WHERE PurchasePrice > 6500 Required A Required B Required C Required D Required E Write a query to find out the dollar amount of each sales transaction. SELECT SUM ([Quantity] * ]) AS Amount FROM WHERE Sales GROUP BY Based on the three tables and the attributes below, answer the question for Requirement A and write SQL commands for Requirements B to E to retrieve the data from the database. Salesltems Sales Inventory V InventoryID V InvoicelD 8 InventoryID 8 InvoicelD Name InvoiceDate OrderDate Quantity UnitPrice BeverageType Caffeinated CustomerID Flavored EmployeelD PurchasePrice 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. 81 Complete this question by entering your answers in the tabs below. Required A Required B Required C Required D Required E Required B What are the foreign keys in the Sales table? (Indicate your answers by selecting an "X" next to the applicable amounts.) 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 InvoicelD FROM Sales WHERE InvoiceDate BETWEEN #3/1/2017# AND #3/31/2017# Required A Required B Required C Required D Required E Which sales transactions were made by the employee whose ID is 'S203 SELECT FROM Sales WHERE EmployeelD 'S2038' Required A Required B Required C Required D Required E List the inventory items with purchase price larger than $6,500. SELECT InvoicelD InvoiceDate FROM Sales WHERE PurchasePrice > 6500 Required A Required B Required C Required D Required E Write a query to find out the dollar amount of each sales transaction. SELECT SUM ([Quantity] * ]) AS Amount FROM WHERE Sales GROUP BY Based on the three tables and the attributes below, answer the question for Requirement A and write SQL commands for Requirements B to E to retrieve the data from the database. Salesltems Sales Inventory V InventoryID V InvoicelD 8 InventoryID 8 InvoicelD Name InvoiceDate OrderDate Quantity UnitPrice BeverageType Caffeinated CustomerID Flavored EmployeelD PurchasePrice 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. 81 Complete this question by entering your answers in the tabs below. Required A Required B Required C Required D Required E Required B What are the foreign keys in the Sales table? (Indicate your answers by selecting an "X" next to the applicable amounts.) 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 InvoicelD FROM Sales WHERE InvoiceDate BETWEEN #3/1/2017# AND #3/31/2017# Required A Required B Required C Required D Required E Which sales transactions were made by the employee whose ID is 'S203 SELECT FROM Sales WHERE EmployeelD 'S2038' Required A Required B Required C Required D Required E List the inventory items with purchase price larger than $6,500. SELECT InvoicelD InvoiceDate FROM Sales WHERE PurchasePrice > 6500 Required A Required B Required C Required D Required E Write a query to find out the dollar amount of each sales transaction. SELECT SUM ([Quantity] * ]) AS Amount FROM WHERE Sales GROUP BY Based on the three tables and the attributes below, answer the question for Requirement A and write SQL commands for Requirements B to E to retrieve the data from the database. Salesltems Sales Inventory V InventoryID V InvoicelD 8 InventoryID 8 InvoicelD Name InvoiceDate OrderDate Quantity UnitPrice BeverageType Caffeinated CustomerID Flavored EmployeelD PurchasePrice 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. 81 Complete this question by entering your answers in the tabs below. Required A Required B Required C Required D Required E Required B What are the foreign keys in the Sales table? (Indicate your answers by selecting an "X" next to the applicable amounts.) 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 InvoicelD FROM Sales WHERE InvoiceDate BETWEEN #3/1/2017# AND #3/31/2017# Required A Required B Required C Required D Required E Which sales transactions were made by the employee whose ID is 'S203 SELECT FROM Sales WHERE EmployeelD 'S2038' Required A Required B Required C Required D Required E List the inventory items with purchase price larger than $6,500. SELECT InvoicelD InvoiceDate FROM Sales WHERE PurchasePrice > 6500 Required A Required B Required C Required D Required E Write a query to find out the dollar amount of each sales transaction. SELECT SUM ([Quantity] * ]) AS Amount FROM WHERE Sales GROUP BY Based on the three tables and the attributes below, answer the question for Requirement A and write SQL commands for Requirements B to E to retrieve the data from the database. Salesltems Sales Inventory V InventoryID V InvoicelD 8 InventoryID 8 InvoicelD Name InvoiceDate OrderDate Quantity UnitPrice BeverageType Caffeinated CustomerID Flavored EmployeelD PurchasePrice 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. 81 Complete this question by entering your answers in the tabs below. Required A Required B Required C Required D Required E Required B What are the foreign keys in the Sales table? (Indicate your answers by selecting an "X" next to the applicable amounts.) 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 InvoicelD FROM Sales WHERE InvoiceDate BETWEEN #3/1/2017# AND #3/31/2017# Required A Required B Required C Required D Required E Which sales transactions were made by the employee whose ID is 'S203 SELECT FROM Sales WHERE EmployeelD 'S2038' Required A Required B Required C Required D Required E List the inventory items with purchase price larger than $6,500. SELECT InvoicelD InvoiceDate FROM Sales WHERE PurchasePrice > 6500 Required A Required B Required C Required D Required E Write a query to find out the dollar amount of each sales transaction. SELECT SUM ([Quantity] * ]) AS Amount FROM WHERE Sales GROUP BY Based on the three tables and the attributes below, answer the question for Requirement A and write SQL commands for Requirements B to E to retrieve the data from the database. Salesltems Sales Inventory V InventoryID V InvoicelD 8 InventoryID 8 InvoicelD Name InvoiceDate OrderDate Quantity UnitPrice BeverageType Caffeinated CustomerID Flavored EmployeelD PurchasePrice 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. 81 Complete this question by entering your answers in the tabs below. Required A Required B Required C Required D Required E Required B What are the foreign keys in the Sales table? (Indicate your answers by selecting an "X" next to the applicable amounts.) 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 InvoicelD FROM Sales WHERE InvoiceDate BETWEEN #3/1/2017# AND #3/31/2017# Required A Required B Required C Required D Required E Which sales transactions were made by the employee whose ID is 'S203 SELECT FROM Sales WHERE EmployeelD 'S2038' Required A Required B Required C Required D Required E List the inventory items with purchase price larger than $6,500. SELECT InvoicelD InvoiceDate FROM Sales WHERE PurchasePrice > 6500 Required A Required B Required C Required D Required E Write a query to find out the dollar amount of each sales transaction. SELECT SUM ([Quantity] * ]) AS Amount FROM WHERE Sales GROUP BY Based on the three tables and the attributes below, answer the question for Requirement A and write SQL commands for Requirements B to E to retrieve the data from the database. Salesltems Sales Inventory V InventoryID V InvoicelD 8 InventoryID 8 InvoicelD Name InvoiceDate OrderDate Quantity UnitPrice BeverageType Caffeinated CustomerID Flavored EmployeelD PurchasePrice 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. 81 Complete this question by entering your answers in the tabs below. Required A Required B Required C Required D Required E Required B What are the foreign keys in the Sales table? (Indicate your answers by selecting an "X" next to the applicable amounts.) 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 InvoicelD FROM Sales WHERE InvoiceDate BETWEEN #3/1/2017# AND #3/31/2017# Required A Required B Required C Required D Required E Which sales transactions were made by the employee whose ID is 'S203 SELECT FROM Sales WHERE EmployeelD 'S2038' Required A Required B Required C Required D Required E List the inventory items with purchase price larger than $6,500. SELECT InvoicelD InvoiceDate FROM Sales WHERE PurchasePrice > 6500 Required A Required B Required C Required D Required E Write a query to find out the dollar amount of each sales transaction. SELECT SUM ([Quantity] * ]) AS Amount FROM WHERE Sales GROUP BY Based on the three tables and the attributes below, answer the question for Requirement A and write SQL commands for Requirements B to E to retrieve the data from the database. Salesltems Sales Inventory V InventoryID V InvoicelD 8 InventoryID 8 InvoicelD Name InvoiceDate OrderDate Quantity UnitPrice BeverageType Caffeinated CustomerID Flavored EmployeelD PurchasePrice 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. 81 Complete this question by entering your answers in the tabs below. Required A Required B Required C Required D Required E Required B What are the foreign keys in the Sales table? (Indicate your answers by selecting an "X" next to the applicable amounts.) 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 InvoicelD FROM Sales WHERE InvoiceDate BETWEEN #3/1/2017# AND #3/31/2017# Required A Required B Required C Required D Required E Which sales transactions were made by the employee whose ID is 'S203 SELECT FROM Sales WHERE EmployeelD 'S2038' Required A Required B Required C Required D Required E List the inventory items with purchase price larger than $6,500. SELECT InvoicelD InvoiceDate FROM Sales WHERE PurchasePrice > 6500 Required A Required B Required C Required D Required E Write a query to find out the dollar amount of each sales transaction. SELECT SUM ([Quantity] * ]) AS Amount FROM WHERE Sales GROUP BY Based on the three tables and the attributes below, answer the question for Requirement A and write SQL commands for Requirements B to E to retrieve the data from the database. Salesltems Sales Inventory V InventoryID V InvoicelD 8 InventoryID 8 InvoicelD Name InvoiceDate OrderDate Quantity UnitPrice BeverageType Caffeinated CustomerID Flavored EmployeelD PurchasePrice 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. 81 Complete this question by entering your answers in the tabs below. Required A Required B Required C Required D Required E Required B What are the foreign keys in the Sales table? (Indicate your answers by selecting an "X" next to the applicable amounts.) 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 InvoicelD FROM Sales WHERE InvoiceDate BETWEEN #3/1/2017# AND #3/31/2017# Required A Required B Required C Required D Required E Which sales transactions were made by the employee whose ID is 'S203 SELECT FROM Sales WHERE EmployeelD 'S2038' Required A Required B Required C Required D Required E List the inventory items with purchase price larger than $6,500. SELECT InvoicelD InvoiceDate FROM Sales WHERE PurchasePrice > 6500 Required A Required B Required C Required D Required E Write a query to find out the dollar amount of each sales transaction. SELECT SUM ([Quantity] * ]) AS Amount FROM WHERE Sales GROUP BY Based on the three tables and the attributes below, answer the question for Requirement A and write SQL commands for Requirements B to E to retrieve the data from the database. Salesltems Sales Inventory V InventoryID V InvoicelD 8 InventoryID 8 InvoicelD Name InvoiceDate OrderDate Quantity UnitPrice BeverageType Caffeinated CustomerID Flavored EmployeelD PurchasePrice 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. 81 Complete this question by entering your answers in the tabs below. Required A Required B Required C Required D Required E Required B What are the foreign keys in the Sales table? (Indicate your answers by selecting an "X" next to the applicable amounts.) 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 InvoicelD FROM Sales WHERE InvoiceDate BETWEEN #3/1/2017# AND #3/31/2017# Required A Required B Required C Required D Required E Which sales transactions were made by the employee whose ID is 'S203 SELECT FROM Sales WHERE EmployeelD 'S2038' Required A Required B Required C Required D Required E List the inventory items with purchase price larger than $6,500. SELECT InvoicelD InvoiceDate FROM Sales WHERE PurchasePrice > 6500 Required A Required B Required C Required D Required E Write a query to find out the dollar amount of each sales transaction. SELECT SUM ([Quantity] * ]) AS Amount FROM WHERE Sales GROUP BY Based on the three tables and the attributes below, answer the question for Requirement A and write SQL commands for Requirements B to E to retrieve the data from the database. Salesltems Sales Inventory V InventoryID V InvoicelD 8 InventoryID 8 InvoicelD Name InvoiceDate OrderDate Quantity UnitPrice BeverageType Caffeinated CustomerID Flavored EmployeelD PurchasePrice 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. 81 Complete this question by entering your answers in the tabs below. Required A Required B Required C Required D Required E Required B What are the foreign keys in the Sales table? (Indicate your answers by selecting an "X" next to the applicable amounts.) 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 InvoicelD FROM Sales WHERE InvoiceDate BETWEEN #3/1/2017# AND #3/31/2017# Required A Required B Required C Required D Required E Which sales transactions were made by the employee whose ID is 'S203 SELECT FROM Sales WHERE EmployeelD 'S2038' Required A Required B Required C Required D Required E List the inventory items with purchase price larger than $6,500. SELECT InvoicelD InvoiceDate FROM Sales WHERE PurchasePrice > 6500 Required A Required B Required C Required D Required E Write a query to find out the dollar amount of each sales transaction. SELECT SUM ([Quantity] * ]) AS Amount FROM WHERE Sales GROUP BY Based on the three tables and the attributes below, answer the question for Requirement A and write SQL commands for Requirements B to E to retrieve the data from the database. Salesltems Sales Inventory V InventoryID V InvoicelD 8 InventoryID 8 InvoicelD Name InvoiceDate OrderDate Quantity UnitPrice BeverageType Caffeinated CustomerID Flavored EmployeelD PurchasePrice 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. 81 Complete this question by entering your answers in the tabs below. Required A Required B Required C Required D Required E Required B What are the foreign keys in the Sales table? (Indicate your answers by selecting an "X" next to the applicable amounts.) 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 InvoicelD FROM Sales WHERE InvoiceDate BETWEEN #3/1/2017# AND #3/31/2017# Required A Required B Required C Required D Required E Which sales transactions were made by the employee whose ID is 'S203 SELECT FROM Sales WHERE EmployeelD 'S2038' Required A Required B Required C Required D Required E List the inventory items with purchase price larger than $6,500. SELECT InvoicelD InvoiceDate FROM Sales WHERE PurchasePrice > 6500 Required A Required B Required C Required D Required E Write a query to find out the dollar amount of each sales transaction. SELECT SUM ([Quantity] * ]) AS Amount FROM WHERE Sales GROUP BY Based on the three tables and the attributes below, answer the question for Requirement A and write SQL commands for Requirements B to E to retrieve the data from the database. Salesltems Sales Inventory V InventoryID V InvoicelD 8 InventoryID 8 InvoicelD Name InvoiceDate OrderDate Quantity UnitPrice BeverageType Caffeinated CustomerID Flavored EmployeelD PurchasePrice 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. 81 Complete this question by entering your answers in the tabs below. Required A Required B Required C Required D Required E Required B What are the foreign keys in the Sales table? (Indicate your answers by selecting an "X" next to the applicable amounts.) 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 InvoicelD FROM Sales WHERE InvoiceDate BETWEEN #3/1/2017# AND #3/31/2017# Required A Required B Required C Required D Required E Which sales transactions were made by the employee whose ID is 'S203 SELECT FROM Sales WHERE EmployeelD 'S2038' Required A Required B Required C Required D Required E List the inventory items with purchase price larger than $6,500. SELECT InvoicelD InvoiceDate FROM Sales WHERE PurchasePrice > 6500 Required A Required B Required C Required D Required E Write a query to find out the dollar amount of each sales transaction. SELECT SUM ([Quantity] * ]) AS Amount FROM WHERE Sales GROUP BY Based on the three tables and the attributes below, answer the question for Requirement A and write SQL commands for Requirements B to E to retrieve the data from the database. Salesltems Sales Inventory V InventoryID V InvoicelD 8 InventoryID 8 InvoicelD Name InvoiceDate OrderDate Quantity UnitPrice BeverageType Caffeinated CustomerID Flavored EmployeelD PurchasePrice 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. 81 Complete this question by entering your answers in the tabs below. Required A Required B Required C Required D Required E Required B What are the foreign keys in the Sales table? (Indicate your answers by selecting an "X" next to the applicable amounts.) 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 InvoicelD FROM Sales WHERE InvoiceDate BETWEEN #3/1/2017# AND #3/31/2017# Required A Required B Required C Required D Required E Which sales transactions were made by the employee whose ID is 'S203 SELECT FROM Sales WHERE EmployeelD 'S2038' Required A Required B Required C Required D Required E List the inventory items with purchase price larger than $6,500. SELECT InvoicelD InvoiceDate FROM Sales WHERE PurchasePrice > 6500 Required A Required B Required C Required D Required E Write a query to find out the dollar amount of each sales transaction. SELECT SUM ([Quantity] * ]) AS Amount FROM WHERE Sales GROUP BY Based on the three tables and the attributes below, answer the question for Requirement A and write SQL commands for Requirements B to E to retrieve the data from the database. Salesltems Sales Inventory V InventoryID V InvoicelD 8 InventoryID 8 InvoicelD Name InvoiceDate OrderDate Quantity UnitPrice BeverageType Caffeinated CustomerID Flavored EmployeelD PurchasePrice 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. 81 Complete this question by entering your answers in the tabs below. Required A Required B Required C Required D Required E Required B What are the foreign keys in the Sales table? (Indicate your answers by selecting an "X" next to the applicable amounts.) 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 InvoicelD FROM Sales WHERE InvoiceDate BETWEEN #3/1/2017# AND #3/31/2017# Required A Required B Required C Required D Required E Which sales transactions were made by the employee whose ID is 'S203 SELECT FROM Sales WHERE EmployeelD 'S2038' Required A Required B Required C Required D Required E List the inventory items with purchase price larger than $6,500. SELECT InvoicelD InvoiceDate FROM Sales WHERE PurchasePrice > 6500 Required A Required B Required C Required D Required E Write a query to find out the dollar amount of each sales transaction. SELECT SUM ([Quantity] * ]) AS Amount FROM WHERE Sales GROUP BY Based on the three tables and the attributes below, answer the question for Requirement A and write SQL commands for Requirements B to E to retrieve the data from the database. Salesltems Sales Inventory V InventoryID V InvoicelD 8 InventoryID 8 InvoicelD Name InvoiceDate OrderDate Quantity UnitPrice BeverageType Caffeinated CustomerID Flavored EmployeelD PurchasePrice 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. 81 Complete this question by entering your answers in the tabs below. Required A Required B Required C Required D Required E Required B What are the foreign keys in the Sales table? (Indicate your answers by selecting an "X" next to the applicable amounts.) 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 InvoicelD FROM Sales WHERE InvoiceDate BETWEEN #3/1/2017# AND #3/31/2017# Required A Required B Required C Required D Required E Which sales transactions were made by the employee whose ID is 'S203 SELECT FROM Sales WHERE EmployeelD 'S2038' Required A Required B Required C Required D Required E List the inventory items with purchase price larger than $6,500. SELECT InvoicelD InvoiceDate FROM Sales WHERE PurchasePrice > 6500 Required A Required B Required C Required D Required E Write a query to find out the dollar amount of each sales transaction. SELECT SUM ([Quantity] * ]) AS Amount FROM WHERE Sales GROUP BY Based on the three tables and the attributes below, answer the question for Requirement A and write SQL commands for Requirements B to E to retrieve the data from the database. Salesltems Sales Inventory V InventoryID V InvoicelD 8 InventoryID 8 InvoicelD Name InvoiceDate OrderDate Quantity UnitPrice BeverageType Caffeinated CustomerID Flavored EmployeelD PurchasePrice 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. 81 Complete this question by entering your answers in the tabs below. Required A Required B Required C Required D Required E Required B What are the foreign keys in the Sales table? (Indicate your answers by selecting an "X" next to the applicable amounts.) 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 InvoicelD FROM Sales WHERE InvoiceDate BETWEEN #3/1/2017# AND #3/31/2017# Required A Required B Required C Required D Required E Which sales transactions were made by the employee whose ID is 'S203 SELECT FROM Sales WHERE EmployeelD 'S2038' Required A Required B Required C Required D Required E List the inventory items with purchase price larger than $6,500. SELECT InvoicelD InvoiceDate FROM Sales WHERE PurchasePrice > 6500 Required A Required B Required C Required D Required E Write a query to find out the dollar amount of each sales transaction. SELECT SUM ([Quantity] * ]) AS Amount FROM WHERE Sales GROUP BY Based on the three tables and the attributes below, answer the question for Requirement A and write SQL commands for Requirements B to E to retrieve the data from the database. Salesltems Sales Inventory V InventoryID V InvoicelD 8 InventoryID 8 InvoicelD Name InvoiceDate OrderDate Quantity UnitPrice BeverageType Caffeinated CustomerID Flavored EmployeelD PurchasePrice 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. 81 Complete this question by entering your answers in the tabs below. Required A Required B Required C Required D Required E Required B What are the foreign keys in the Sales table? (Indicate your answers by selecting an "X" next to the applicable amounts.) 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 InvoicelD FROM Sales WHERE InvoiceDate BETWEEN #3/1/2017# AND #3/31/2017# Required A Required B Required C Required D Required E Which sales transactions were made by the employee whose ID is 'S203 SELECT FROM Sales WHERE EmployeelD 'S2038' Required A Required B Required C Required D Required E List the inventory items with purchase price larger than $6,500. SELECT InvoicelD InvoiceDate FROM Sales WHERE PurchasePrice > 6500 Required A Required B Required C Required D Required E Write a query to find out the dollar amount of each sales transaction. SELECT SUM ([Quantity] * ]) AS Amount FROM WHERE Sales GROUP BY Based on the three tables and the attributes below, answer the question for Requirement A and write SQL commands for Requirements B to E to retrieve the data from the database. Salesltems Sales Inventory V InventoryID V InvoicelD 8 InventoryID 8 InvoicelD Name InvoiceDate OrderDate Quantity UnitPrice BeverageType Caffeinated CustomerID Flavored EmployeelD PurchasePrice 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. 81 Complete this question by entering your answers in the tabs below. Required A Required B Required C Required D Required E Required B What are the foreign keys in the Sales table? (Indicate your answers by selecting an "X" next to the applicable amounts.) 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 InvoicelD FROM Sales WHERE InvoiceDate BETWEEN #3/1/2017# AND #3/31/2017# Required A Required B Required C Required D Required E Which sales transactions were made by the employee whose ID is 'S203 SELECT FROM Sales WHERE EmployeelD 'S2038' Required A Required B Required C Required D Required E List the inventory items with purchase price larger than $6,500. SELECT InvoicelD InvoiceDate FROM Sales WHERE PurchasePrice > 6500 Required A Required B Required C Required D Required E Write a query to find out the dollar amount of each sales transaction. SELECT SUM ([Quantity] * ]) AS Amount FROM WHERE Sales GROUP BY Based on the three tables and the attributes below, answer the question for Requirement A and write SQL commands for Requirements B to E to retrieve the data from the database. Salesltems Sales Inventory V InventoryID V InvoicelD 8 InventoryID 8 InvoicelD Name InvoiceDate OrderDate Quantity UnitPrice BeverageType Caffeinated CustomerID Flavored EmployeelD PurchasePrice 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. 81 Complete this question by entering your answers in the tabs below. Required A Required B Required C Required D Required E Required B What are the foreign keys in the Sales table? (Indicate your answers by selecting an "X" next to the applicable amounts.) 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 InvoicelD FROM Sales WHERE InvoiceDate BETWEEN #3/1/2017# AND #3/31/2017# Required A Required B Required C Required D Required E Which sales transactions were made by the employee whose ID is 'S203 SELECT FROM Sales WHERE EmployeelD 'S2038' Required A Required B Required C Required D Required E List the inventory items with purchase price larger than $6,500. SELECT InvoicelD InvoiceDate FROM Sales WHERE PurchasePrice > 6500 Required A Required B Required C Required D Required E Write a query to find out the dollar amount of each sales transaction. SELECT SUM ([Quantity] * ]) AS Amount FROM WHERE Sales GROUP BY Based on the three tables and the attributes below, answer the question for Requirement A and write SQL commands for Requirements B to E to retrieve the data from the database. Salesltems Sales Inventory V InventoryID V InvoicelD 8 InventoryID 8 InvoicelD Name InvoiceDate OrderDate Quantity UnitPrice BeverageType Caffeinated CustomerID Flavored EmployeelD PurchasePrice 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. 81 Complete this question by entering your answers in the tabs below. Required A Required B Required C Required D Required E Required B What are the foreign keys in the Sales table? (Indicate your answers by selecting an "X" next to the applicable amounts.) 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 InvoicelD FROM Sales WHERE InvoiceDate BETWEEN #3/1/2017# AND #3/31/2017# Required A Required B Required C Required D Required E Which sales transactions were made by the employee whose ID is 'S203 SELECT FROM Sales WHERE EmployeelD 'S2038' Required A Required B Required C Required D Required E List the inventory items with purchase price larger than $6,500. SELECT InvoicelD InvoiceDate FROM Sales WHERE PurchasePrice > 6500 Required A Required B Required C Required D Required E Write a query to find out the dollar amount of each sales transaction. SELECT SUM ([Quantity] * ]) AS Amount FROM WHERE Sales GROUP BY Based on the three tables and the attributes below, answer the question for Requirement A and write SQL commands for Requirements B to E to retrieve the data from the database. Salesltems Sales Inventory V InventoryID V InvoicelD 8 InventoryID 8 InvoicelD Name InvoiceDate OrderDate Quantity UnitPrice BeverageType Caffeinated CustomerID Flavored EmployeelD PurchasePrice 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. 81 Complete this question by entering your answers in the tabs below. Required A Required B Required C Required D Required E Required B What are the foreign keys in the Sales table? (Indicate your answers by selecting an "X" next to the applicable amounts.) 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 InvoicelD FROM Sales WHERE InvoiceDate BETWEEN #3/1/2017# AND #3/31/2017# Required A Required B Required C Required D Required E Which sales transactions were made by the employee whose ID is 'S203 SELECT FROM Sales WHERE EmployeelD 'S2038' Required A Required B Required C Required D Required E List the inventory items with purchase price larger than $6,500. SELECT InvoicelD InvoiceDate FROM Sales WHERE PurchasePrice > 6500 Required A Required B Required C Required D Required E Write a query to find out the dollar amount of each sales transaction. SELECT SUM ([Quantity] * ]) AS Amount FROM WHERE Sales GROUP BY Based on the three tables and the attributes below, answer the question for Requirement A and write SQL commands for Requirements B to E to retrieve the data from the database. Salesltems Sales Inventory V InventoryID V InvoicelD 8 InventoryID 8 InvoicelD Name InvoiceDate OrderDate Quantity UnitPrice BeverageType Caffeinated CustomerID Flavored EmployeelD PurchasePrice 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. 81 Complete this question by entering your answers in the tabs below. Required A Required B Required C Required D Required E Required B What are the foreign keys in the Sales table? (Indicate your answers by selecting an "X" next to the applicable amounts.) 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 InvoicelD FROM Sales WHERE InvoiceDate BETWEEN #3/1/2017# AND #3/31/2017# Required A Required B Required C Required D Required E Which sales transactions were made by the employee whose ID is 'S203 SELECT FROM Sales WHERE EmployeelD 'S2038' Required A Required B Required C Required D Required E List the inventory items with purchase price larger than $6,500. SELECT InvoicelD InvoiceDate FROM Sales WHERE PurchasePrice > 6500 Required A Required B Required C Required D Required E Write a query to find out the dollar amount of each sales transaction. SELECT SUM ([Quantity] * ]) AS Amount FROM WHERE Sales GROUP BY Based on the three tables and the attributes below, answer the question for Requirement A and write SQL commands for Requirements B to E to retrieve the data from the database. Salesltems Sales Inventory V InventoryID V InvoicelD 8 InventoryID 8 InvoicelD Name InvoiceDate OrderDate Quantity UnitPrice BeverageType Caffeinated CustomerID Flavored EmployeelD PurchasePrice 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. 81 Complete this question by entering your answers in the tabs below. Required A Required B Required C Required D Required E Required B What are the foreign keys in the Sales table? (Indicate your answers by selecting an "X" next to the applicable amounts.) 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 InvoicelD FROM Sales WHERE InvoiceDate BETWEEN #3/1/2017# AND #3/31/2017# Required A Required B Required C Required D Required E Which sales transactions were made by the employee whose ID is 'S203 SELECT FROM Sales WHERE EmployeelD 'S2038' Required A Required B Required C Required D Required E List the inventory items with purchase price larger than $6,500. SELECT InvoicelD InvoiceDate FROM Sales WHERE PurchasePrice > 6500 Required A Required B Required C Required D Required E Write a query to find out the dollar amount of each sales transaction. SELECT SUM ([Quantity] * ]) AS Amount FROM WHERE Sales GROUP BY Based on the three tables and the attributes below, answer the question for Requirement A and write SQL commands for Requirements B to E to retrieve the data from the database. Salesltems Sales Inventory V InventoryID V InvoicelD 8 InventoryID 8 InvoicelD Name InvoiceDate OrderDate Quantity UnitPrice BeverageType Caffeinated CustomerID Flavored EmployeelD PurchasePrice 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. 81 Complete this question by entering your answers in the tabs below. Required A Required B Required C Required D Required E Required B What are the foreign keys in the Sales table? (Indicate your answers by selecting an "X" next to the applicable amounts.) 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 InvoicelD FROM Sales WHERE InvoiceDate BETWEEN #3/1/2017# AND #3/31/2017# Required A Required B Required C Required D Required E Which sales transactions were made by the employee whose ID is 'S203 SELECT FROM Sales WHERE EmployeelD 'S2038' Required A Required B Required C Required D Required E List the inventory items with purchase price larger than $6,500. SELECT InvoicelD InvoiceDate FROM Sales WHERE PurchasePrice > 6500 Required A Required B Required C Required D Required E Write a query to find out the dollar amount of each sales transaction. SELECT SUM ([Quantity] * ]) AS Amount FROM WHERE Sales GROUP BY Based on the three tables and the attributes below, answer the question for Requirement A and write SQL commands for Requirements B to E to retrieve the data from the database. Salesltems Sales Inventory V InventoryID V InvoicelD 8 InventoryID 8 InvoicelD Name InvoiceDate OrderDate Quantity UnitPrice BeverageType Caffeinated CustomerID Flavored EmployeelD PurchasePrice 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. 81 Complete this question by entering your answers in the tabs below. Required A Required B Required C Required D Required E Required B What are the foreign keys in the Sales table? (Indicate your answers by selecting an "X" next to the applicable amounts.) 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 InvoicelD FROM Sales WHERE InvoiceDate BETWEEN #3/1/2017# AND #3/31/2017# Required A Required B Required C Required D Required E Which sales transactions were made by the employee whose ID is 'S203 SELECT FROM Sales WHERE EmployeelD 'S2038' Required A Required B Required C Required D Required E List the inventory items with purchase price larger than $6,500. SELECT InvoicelD InvoiceDate FROM Sales WHERE PurchasePrice > 6500 Required A Required B Required C Required D Required E Write a query to find out the dollar amount of each sales transaction. SELECT SUM ([Quantity] * ]) AS Amount FROM WHERE Sales GROUP BY Based on the three tables and the attributes below, answer the question for Requirement A and write SQL commands for Requirements B to E to retrieve the data from the database. Salesltems Sales Inventory V InventoryID V InvoicelD 8 InventoryID 8 InvoicelD Name InvoiceDate OrderDate Quantity UnitPrice BeverageType Caffeinated CustomerID Flavored EmployeelD PurchasePrice 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. 81 Complete this question by entering your answers in the tabs below. Required A Required B Required C Required D Required E Required B What are the foreign keys in the Sales table? (Indicate your answers by selecting an "X" next to the applicable amounts.) 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 InvoicelD FROM Sales WHERE InvoiceDate BETWEEN #3/1/2017# AND #3/31/2017# Required A Required B Required C Required D Required E Which sales transactions were made by the employee whose ID is 'S203 SELECT FROM Sales WHERE EmployeelD 'S2038' Required A Required B Required C Required D Required E List the inventory items with purchase price larger than $6,500. SELECT InvoicelD InvoiceDate FROM Sales WHERE PurchasePrice > 6500 Required A Required B Required C Required D Required E Write a query to find out the dollar amount of each sales transaction. SELECT SUM ([Quantity] * ]) AS Amount FROM WHERE Sales GROUP BY Based on the three tables and the attributes below, answer the question for Requirement A and write SQL commands for Requirements B to E to retrieve the data from the database. Salesltems Sales Inventory V InventoryID V InvoicelD 8 InventoryID 8 InvoicelD Name InvoiceDate OrderDate Quantity UnitPrice BeverageType Caffeinated CustomerID Flavored EmployeelD PurchasePrice 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. 81 Complete this question by entering your answers in the tabs below. Required A Required B Required C Required D Required E Required B What are the foreign keys in the Sales table? (Indicate your answers by selecting an "X" next to the applicable amounts.) 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 InvoicelD FROM Sales WHERE InvoiceDate BETWEEN #3/1/2017# AND #3/31/2017# Required A Required B Required C Required D Required E Which sales transactions were made by the employee whose ID is 'S203 SELECT FROM Sales WHERE EmployeelD 'S2038' Required A Required B Required C Required D Required E List the inventory items with purchase price larger than $6,500. SELECT InvoicelD InvoiceDate FROM Sales WHERE PurchasePrice > 6500 Required A Required B Required C Required D Required E Write a query to find out the dollar amount of each sales transaction. SELECT SUM ([Quantity] * ]) AS Amount FROM WHERE Sales GROUP BY Based on the three tables and the attributes below, answer the question for Requirement A and write SQL commands for Requirements B to E to retrieve the data from the database. Salesltems Sales Inventory V InventoryID V InvoicelD 8 InventoryID 8 InvoicelD Name InvoiceDate OrderDate Quantity UnitPrice BeverageType Caffeinated CustomerID Flavored EmployeelD PurchasePrice 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. 81 Complete this question by entering your answers in the tabs below. Required A Required B Required C Required D Required E Required B What are the foreign keys in the Sales table? (Indicate your answers by selecting an "X" next to the applicable amounts.) 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 InvoicelD FROM Sales WHERE InvoiceDate BETWEEN #3/1/2017# AND #3/31/2017# Required A Required B Required C Required D Required E Which sales transactions were made by the employee whose ID is 'S203 SELECT FROM Sales WHERE EmployeelD 'S2038' Required A Required B Required C Required D Required E List the inventory items with purchase price larger than $6,500. SELECT InvoicelD InvoiceDate FROM Sales WHERE PurchasePrice > 6500 Required A Required B Required C Required D Required E Write a query to find out the dollar amount of each sales transaction. SELECT SUM ([Quantity] * ]) AS Amount FROM WHERE Sales GROUP BY Based on the three tables and the attributes below, answer the question for Requirement A and write SQL commands for Requirements B to E to retrieve the data from the database. Salesltems Sales Inventory V InventoryID V InvoicelD 8 InventoryID 8 InvoicelD Name InvoiceDate OrderDate Quantity UnitPrice BeverageType Caffeinated CustomerID Flavored EmployeelD PurchasePrice 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. 81 Complete this question by entering your answers in the tabs below. Required A Required B Required C Required D Required E Required B What are the foreign keys in the Sales table? (Indicate your answers by selecting an "X" next to the applicable amounts.) 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 InvoicelD FROM Sales WHERE InvoiceDate BETWEEN #3/1/2017# AND #3/31/2017# Required A Required B Required C Required D Required E Which sales transactions were made by the employee whose ID is 'S203 SELECT FROM Sales WHERE EmployeelD 'S2038' Required A Required B Required C Required D Required E List the inventory items with purchase price larger than $6,500. SELECT InvoicelD InvoiceDate FROM Sales WHERE PurchasePrice > 6500 Required A Required B Required C Required D Required E Write a query to find out the dollar amount of each sales transaction. SELECT SUM ([Quantity] * ]) AS Amount FROM WHERE Sales GROUP BY Based on the three tables and the attributes below, answer the question for Requirement A and write SQL commands for Requirements B to E to retrieve the data from the database. Salesltems Sales Inventory V InventoryID V InvoicelD 8 InventoryID 8 InvoicelD Name InvoiceDate OrderDate Quantity UnitPrice BeverageType Caffeinated CustomerID Flavored EmployeelD PurchasePrice 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. 81 Complete this question by entering your answers in the tabs below. Required A Required B Required C Required D Required E Required B What are the foreign keys in the Sales table? (Indicate your answers by selecting an "X" next to the applicable amounts.) 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 InvoicelD FROM Sales WHERE InvoiceDate BETWEEN #3/1/2017# AND #3/31/2017# Required A Required B Required C Required D Required E Which sales transactions were made by the employee whose ID is 'S203 SELECT FROM Sales WHERE EmployeelD 'S2038' Required A Required B Required C Required D Required E List the inventory items with purchase price larger than $6,500. SELECT InvoicelD InvoiceDate FROM Sales WHERE PurchasePrice > 6500 Required A Required B Required C Required D Required E Write a query to find out the dollar amount of each sales transaction. SELECT SUM ([Quantity] * ]) AS Amount FROM WHERE Sales GROUP BY Based on the three tables and the attributes below, answer the question for Requirement A and write SQL commands for Requirements B to E to retrieve the data from the database. Salesltems Sales Inventory V InventoryID V InvoicelD 8 InventoryID 8 InvoicelD Name InvoiceDate OrderDate Quantity UnitPrice BeverageType Caffeinated CustomerID Flavored EmployeelD PurchasePrice 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. 81 Complete this question by entering your answers in the tabs below. Required A Required B Required C Required D Required E Required B What are the foreign keys in the Sales table? (Indicate your answers by selecting an "X" next to the applicable amounts.) 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 InvoicelD FROM Sales WHERE InvoiceDate BETWEEN #3/1/2017# AND #3/31/2017# Required A Required B Required C Required D Required E Which sales transactions were made by the employee whose ID is 'S203 SELECT FROM Sales WHERE EmployeelD 'S2038' Required A Required B Required C Required D Required E List the inventory items with purchase price larger than $6,500. SELECT InvoicelD InvoiceDate FROM Sales WHERE PurchasePrice > 6500 Required A Required B Required C Required D Required E Write a query to find out the dollar amount of each sales transaction. SELECT SUM ([Quantity] * ]) AS Amount FROM WHERE Sales GROUP BY Based on the three tables and the attributes below, answer the question for Requirement A and write SQL commands for Requirements B to E to retrieve the data from the database. Salesltems Sales Inventory V InventoryID V InvoicelD 8 InventoryID 8 InvoicelD Name InvoiceDate OrderDate Quantity UnitPrice BeverageType Caffeinated CustomerID Flavored EmployeelD PurchasePrice 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. 81 Complete this question by entering your answers in the tabs below. Required A Required B Required C Required D Required E Required B What are the foreign keys in the Sales table? (Indicate your answers by selecting an "X" next to the applicable amounts.) 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 InvoicelD FROM Sales WHERE InvoiceDate BETWEEN #3/1/2017# AND #3/31/2017# Required A Required B Required C Required D Required E Which sales transactions were made by the employee whose ID is 'S203 SELECT FROM Sales WHERE EmployeelD 'S2038' Required A Required B Required C Required D Required E List the inventory items with purchase price larger than $6,500. SELECT InvoicelD InvoiceDate FROM Sales WHERE PurchasePrice > 6500 Required A Required B Required C Required D Required E Write a query to find out the dollar amount of each sales transaction. SELECT SUM ([Quantity] * ]) AS Amount FROM WHERE Sales GROUP BY Based on the three tables and the attributes below, answer the question for Requirement A and write SQL commands for Requirements B to E to retrieve the data from the database. Salesltems Sales Inventory V InventoryID V InvoicelD 8 InventoryID 8 InvoicelD Name InvoiceDate OrderDate Quantity UnitPrice BeverageType Caffeinated CustomerID Flavored EmployeelD PurchasePrice 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. 81 Complete this question by entering your answers in the tabs below. Required A Required B Required C Required D Required E Required B What are the foreign keys in the Sales table? (Indicate your answers by selecting an "X" next to the applicable amounts.) 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 InvoicelD FROM Sales WHERE InvoiceDate BETWEEN #3/1/2017# AND #3/31/2017# Required A Required B Required C Required D Required E Which sales transactions were made by the employee whose ID is 'S203 SELECT FROM Sales WHERE EmployeelD 'S2038' Required A Required B Required C Required D Required E List the inventory items with purchase price larger than $6,500. SELECT InvoicelD InvoiceDate FROM Sales WHERE PurchasePrice > 6500 Required A Required B Required C Required D Required E Write a query to find out the dollar amount of each sales transaction. SELECT SUM ([Quantity] * ]) AS Amount FROM WHERE Sales GROUP BY Based on the three tables and the attributes below, answer the question for Requirement A and write SQL commands for Requirements B to E to retrieve the data from the database. Salesltems Sales Inventory V InventoryID V InvoicelD 8 InventoryID 8 InvoicelD Name InvoiceDate OrderDate Quantity UnitPrice BeverageType Caffeinated CustomerID Flavored EmployeelD PurchasePrice 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. 81 Complete this question by entering your answers in the tabs below. Required A Required B Required C Required D Required E Required B What are the foreign keys in the Sales table? (Indicate your answers by selecting an "X" next to the applicable amounts.) 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 InvoicelD FROM Sales WHERE InvoiceDate BETWEEN #3/1/2017# AND #3/31/2017# Required A Required B Required C Required D Required E Which sales transactions were made by the employee whose ID is 'S203 SELECT FROM Sales WHERE EmployeelD 'S2038' Required A Required B Required C Required D Required E List the inventory items with purchase price larger than $6,500. SELECT InvoicelD InvoiceDate FROM Sales WHERE PurchasePrice > 6500 Required A Required B Required C Required D Required E Write a query to find out the dollar amount of each sales transaction. SELECT SUM ([Quantity] * ]) AS Amount FROM WHERE Sales GROUP BY
Expert Answer:
Related Book For
Taxes and Business Strategy A Planning Approach
ISBN: 9780132752671
5th edition
Authors: Myron Scholes, Mark Wolfson, Merle Erickson, Michelle Hanlon
Posted Date:
Students also viewed these databases questions
-
What are the foreign tax credit limitations and why do they exist?
-
Write a query to display the employee number, last name, e-mail address, title, and department name of each employee whose job title ends in the word ASSOCIATE. Sort the output by department name and...
-
Write a query to display the employee number, last name, first name, and sum of invoice totals for all employees who completed an invoice. Sort the output by employee last name and then by firstname....
-
A tank of water of length 2 0 m , 1 0 m , and height 5 m is filled with water of density 1 . 2 g / cm 3 . Find the pressure ( in Pa ) of water on one of the walls at a point 5 9 cm above the bottom.
-
Write a matrix equation equivalent to the system of equations. a. 2x - 3y = 7, x + 5y = -6 b. -x + y = 3, 5x - 4y = 16 c. x + y - 2z = 6, 3x - y + z = 7, 2x + 5y - 3z = 8
-
An actuary at an insurance company wants to determine whether the number of hours of safety driving classes can be used to predict the number of driving accidents for each driver. Identify the...
-
There is a market for bets on the outcome of a coin toss. The possible outcomes are heads, tails, and edge. There are three assets traded in that market: Asset A pays \(\$ 1\) independent of the...
-
The Kwestel Company adopted the dollar-value LIFO method for inventory valuation at the beginning of 2006. The following information about the inventory at the end of each year is available from the...
-
You are evaluating a project with the following cash flows: initial investment is $ - 1 1 , and the expected cash flows for years 1 - 3 are $ 6 , $ 1 4 and $ 1 1 ( all cash flows are in millions of...
-
In one-hundred words or less using Richard Daft and Robert Lengel's Media Richness Theory, define the theory then explain a situation where the inappropriate medium was used by YOU and what would...
-
Sketch a diagram to illustrate the competitive market for bread, showing the equilibrium where 5,000 loaves are sold at a price of 2.00. 2. Suppose that the bakeries get together to form a cartel....
-
Suppose there are three buyers of candy in a market: Tex, Dex, and Rex. The market demand and the individual demands of Tex, Dex, and Rex are shown on the next page. a. Fill in the table for the...
-
In response to the prosecutors questions, a lay witness who is a high school graduate testifies as follows: I measured the defendants skid marks, and I believe he was driving at a speed of at least...
-
Should professional sports be pressured to field teams that reflect the population of the US? Would you advocate the same policy for General Motors?
-
A defendant is being tried for first-degree murder. The prosecutor presents an eyewitness to the victims being shot. After asking the witness some preliminary questions, the prosecutor begins a...
-
An elderly widow whose income was derived primarily from Social Security and a small pension owned $100,000 in government bonds that she inherited from her late husband. Other than her home and a...
-
An owner can lease his building for $150,000 per year for three years.The explicit cost of maintaining the building is $50,000 and the implicit cost is $65,000. All revenues are received and costs...
-
When the Department of Homeland Security created a color-coded system to prepare government officials and the public against terrorist attacks, what did it do right and what did it do wrong?
-
How does the length of time that the pension contribution will remain in the pension account affect whether pension is preferred to salary? Under what conditions is the duration of the pension...
-
Suppose a firm has a tax loss in the current period of $10 million, which when added to prior tax losses gives it an NOL carry forward of $15 million. The top statutory tax rate for the foreseeable...
-
You are a summer associate at a large Wall Street investment bank and your direct supervisor has in-formed you that the Sunglass Hut (the acquirer) has engaged your firm to analyze the prospect of...
-
Why is it important to talk about selling solutions instead of products or services? How does selling solutions further the success of a relationship-selling approach?
-
Has transactional selling gone the way of the dinosaur? That is, are there ever any situations in which a transactional approach to selling would be an appropriate approach today? If so, what are...
-
When a firm shifts from transactional selling to a value-added approach, a number of changes have to take place in the way a salesperson approaches customers as well as his or her own job. List as...
Study smarter with the SolutionInn App