Question
1. Use the following tables, write the SQL code which shows each supplier ID and the total quantity of purchases from each supplier. 2.Use the
1. Use the following tables, write the SQL code which shows each supplier ID and the total quantity of purchases from each supplier.
2.Use the following tables, write the SQL code which shows the total dollar amount of purchases for each raw material description.
3.Use the following tables, write the SQL code which shows each supplier state and how many suppliers are in each state, in the order of lowest to highest number of suppliers.
4. Use the following tables, write the SQL code which shows each employee ID, email address, and the total dollar amount of purchases for each employee.
5. Use the following tables, write the SQL code which shows each purchase order ID that was made during June 2018 with quantity purchased less or equal to 8.
Use the following tables, write the SQL code which shows each purchase order ID that was made during June 2018 with quantity purchased less or equal to 8. Raw_Material Table Attribute Raw_Material_Code (PK) Raw_Material_Description Raw_Material_Price Description of Attribute Unique identifier for each raw material Descriptive name for each raw material Price of each raw material Supplier Table Attribute Supplier_ID (PK) Business_Name Supplier_Address Supplier_City Supplier_St Supplier_Zip Description of Attribute Unique identifier for each supplier The name of the supplier The physical street address of the supplier The physical city where the supplier is located The physical state where the supplier is located The zip code of the city where the supplier is located Employee Table Attribute Employee_ID (PK) Last Name First Name Email Phone_Number Description of Attribute Unique identifier for each employee Last name of the employee First name of the employee Email address of the employee Phone number of the employee Purchase_Order Table Attribute Purchase_Order_ID (PK) Purchase_Order_Date Employee_ID (FK) Description of Attribute Unique identifier for each purchase order Date each purchase order was placed Unique identifier for the employee who created the record Unique identifier for each supplier Unique identifier for each raw material Quantity of each raw material purchased on the transaction Price of each raw material Supplier_ID (FK) Raw_Material_Code (FK) Quantity_Purchased Raw_Material_Price Use the following tables, write the SQL code which shows each purchase order ID that was made during June 2018 with quantity purchased less or equal to 8. Raw_Material Table Attribute Raw_Material_Code (PK) Raw_Material_Description Raw_Material_Price Description of Attribute Unique identifier for each raw material Descriptive name for each raw material Price of each raw material Supplier Table Attribute Supplier_ID (PK) Business_Name Supplier_Address Supplier_City Supplier_St Supplier_Zip Description of Attribute Unique identifier for each supplier The name of the supplier The physical street address of the supplier The physical city where the supplier is located The physical state where the supplier is located The zip code of the city where the supplier is located Employee Table Attribute Employee_ID (PK) Last Name First Name Email Phone_Number Description of Attribute Unique identifier for each employee Last name of the employee First name of the employee Email address of the employee Phone number of the employee Purchase_Order Table Attribute Purchase_Order_ID (PK) Purchase_Order_Date Employee_ID (FK) Description of Attribute Unique identifier for each purchase order Date each purchase order was placed Unique identifier for the employee who created the record Unique identifier for each supplier Unique identifier for each raw material Quantity of each raw material purchased on the transaction Price of each raw material Supplier_ID (FK) Raw_Material_Code (FK) Quantity_Purchased Raw_Material_Price
Step by Step Solution
There are 3 Steps involved in it
Step: 1
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-text-image.webp)
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Step: 3
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started