Question: Based on the three tables and the attributes below, write SQL commands for each question to retrieve the data from the database Required: a. What

Based on the three tables and the attributes below, write SQL commands for each question to retrieve the data from the database 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. Based on the three tables and the attributes below, write SQL commands for each question to retrieve the data from the database 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
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
