I need help. Asap
y/ bbhosted.cuny.edu - Y x Bb Announcements - 202 x 5 Connect X ACC 3202 Syllabus Fal x | Mail - TOEYADANAR.Z X M Inbox (12,008) - toeya( x New Tab X + ezto.mheducation.com/ext/map/index.html?_con=con&external_browser=0&launchUrl=https%253A%252F%252Fnewconnect.mheducation.com%252F... * AIS Comprehensive Exam i Saved Help Save & Exit Submit 38 Use the following tables, write the SQL code which shows each employee's Last Name, First Name, and the total quantity of purchases for each employee. Raw_Material Table Attribute Description of Attribute 4 Raw_Material_Code (PK) Unique identifier for each raw material points Raw_Material_Description Descriptive name for each raw material Raw_Material_Price Price of each raw material 01:58:42 Purchase_Order Table Attribute Description of Attribute eBook Purchase_Order_ID (PK) Unique identifier for each purchase order Purchase_Order_Date Date each purchase order was placed Employee_ID (FK) Unique identifier for the employee who created the record Supplier_ID (FK) Unique identifier for each supplier Raw_Material_Code (FK) Unique identifier for each raw material Quantity_Purchased Quantity of each raw material purchased on the transaction Raw_Material_Price Price of each raw material Supplier Table Attribute Description of Attribute Supplier_ID (PK) Unique identifier for each supplier Business_Name The name of the supplier Supplier_Address The physical street address of the supplier Supplier_City The physical city where the supplier is located Supplier_St The physical state where the supplier is located Supplier_Zip The zip code of the city where the supplier is located This question will be sent to your instructor for grading. Mc Graw y/ bbhosted.cuny.edu - Y x Bb Announcements - 202 x 5 Connect X 5 ACC 3202 Syllabus Fal x |Mail - TOEYADANAR.Z X M Inbox (12,008) - toeya x New Tab X + ezto.mheducation.com/ext/map/index.html?_con=con&external_browser=0&launchUrl=https%253A%252F%252Fnewconnect.mheducation.com%252F... * AIS Comprehensive Exam i Saved Help Save & Exit Submit 38 Purchase_Order Table Attribute Description of Attribute Purchase_Order_ID (PK) Unique identifier for each purchase order Purchase_Order_Date Date each purchase order was placed 4 Employee_ID (FK) Unique identifier for the employee who created the points record Supplier_ID (FK) Unique identifier for each supplier 01:58:34 Raw_Material_Code (FK) Unique identifier for each raw material Quantity_Purchased Quantity of each raw material purchased on the transaction Raw_Material_Price Price of each raw material eBook Supplier Table Attribute Description of Attribute Supplier_ID (PK) Unique identifier for each supplier Business_Name The name of the supplier Supplier_Address The physical street address of the supplier Supplier_City The physical city where the supplier is located Supplier_St The physical state where the supplier is located Supplier_Zip The zip code of the city where the supplier is located Employee Table Attribute Description of Attribute Employee_ID (PK) Unique identifier for each employee Last Name Last name of the employee First Name First name of the employee Email Email address of the employee Phone_Number Phone number of the employee This question will be sent to your instructor for grading. Mc Graw Hilly/ bbhosted.cuny.edu - Y x Bb Announcements - 202 x 5 Connect X ACC 3202 Syllabus Fal x ) Mail - TOEYADANAR.Z X M Inbox (12,008) - toeya( x New Tab X + ezto.mheducation.com/ext/map/index.html?_con=con&external_browser=0&launchUrl=https%253A%252F%252Fnewconnect.mheducation.com%252F... * AIS Comprehensive Exam i Saved Help Save & Exit Submit 37 Use the following tables, write the SQL code which shows the total quantity of purchases for each raw material code. Raw_Material Table Attribute Description of Attribute Raw_Material_Code (PK) Unique identifier for each raw material 4 Raw_Material_Description Descriptive name for each raw material points Raw_Material_Price Price of each raw material 01:58:17 Purchase_Order Table Attribute Description of Attribute Purchase_Order_ID (PK) Unique identifier for each purchase order eBook Purchase_Order_Date Date each purchase order was placed Employee_ID (FK) Unique identifier for the employee who created the record Supplier_ID (FK) Unique identifier for each supplier Raw_Material_Code (FK) Unique identifier for each raw material Quantity_Purchased Quantity of each raw material purchased on the transaction Raw_Material_Price Price of each raw material Supplier Table Attribute Description of Attribute Supplier_ID (PK) Unique identifier for each supplier Business_Name The name of the supplier Supplier_Address The physical street address of the supplier Supplier_City The physical city where the supplier is located Supplier_St The physical state where the supplier is located Supplier_Zip The zip code of the city where the supplier is located Employee Table O This question will be sent to your instructor for grading. Mc Graw y/ bbhosted.cuny.edu - Yahoo x Bb Announcements - 2020 Fall x Connect X ACC 3202 Syllabus Fall 202( x M Inbox (12,008) - toeyadanar x New Tab X + ezto.mheducation.com/ext/map/index.html?_con=con&external_browser=0&launchUrl=https%253A%252F%252Fnewconnect.mheducation.com%252F... AIS Comprehensive Exam i Saved Help Save & Exit Submit Raw_Material_Price Price of each raw material 37 Purchase_Order Table Attribute Description of Attribute Purchase_Order_ID (PK) Unique identifier for each purchase order Purchase_Order_Date Date each purchase order was placed 4 Employee_ID (FK) Unique identifier for the employee who created the points record Supplier_ID (FK) Unique identifier for each supplier 01:58:09 Raw_Material_Code (FK) Unique identifier for each raw material Quantity_Purchased Quantity of each raw material purchased on the transaction Raw_Material_Price Price of each raw material eBook Supplier Table Attribute Description of Attribute Supplier_ID (PK) Unique identifier for each supplier Business_Name The name of the supplier Supplier_Address The physical street address of the supplier Supplier_City The physical city where the supplier is located Supplier_St The physical state where the supplier is located Supplier_Zip The zip code of the city where the supplier is located Employee Table Attribute Description of Attribute Employee_ID (PK) Unique identifier for each employee Last Name Last name of the employee First Name First name of the employee Email Email address of the employee Phone_Number Phone number of the employee This question will be sent to your instructor for grading. Mc Graw y/ bbhosted.cuny.edu - Yahoo x Bb Announcements - 2020 Fall x Connect X ACC 3202 Syllabus Fall 202( x M Inbox (12,008) - toeyadanar x New Tab X + ezto.mheducation.com/ext/map/index.html?_con=con&external_browser=0&launchUrl=https%253A%252F%252Fnewconnect.mheducation.com%252F... * AIS Comprehensive Exam i Saved Help Save & Exit Submit Use the following tables, write the SQL code which shows each supplier name and the total dollar amount of purchases from each supplier. 36 Raw_Material Table Attribute Description of Attribute Raw_Material_Code (PK) Unique identifier for each raw material 4 Raw_Material_Description Descriptive name for each raw material points Raw_Material_Price Price of each raw material 01:58:04 Purchase_Order Table Attribute Description of Attribute Purchase_Order_ID (PK) Unique identifier for each purchase order eBook Purchase_Order_Date Date each purchase order was placed Employee_ID (FK) Unique identifier for the employee who created the record Supplier_ID (FK) Unique identifier for each supplier Raw_Material_Code (FK) Unique identifier for each raw material Quantity_Purchased Quantity of each raw material purchased on the transaction Raw_Material_Price Price of each raw material Supplier Table Attribute Description of Attribute Supplier_ID (PK) Unique identifier for each supplier Business_Name The name of the supplier Supplier_Address The physical street address of the supplier Supplier_City The physical city where the supplier is located Supplier_St The physical state where the supplier is located Supplier_Zip The zip code of the city where the supplier is located Employee Table O This question will be sent to your instructor for grading. Mc Graw y/ bbhosted.cuny.edu - Yahoo Se x Bb Announcements - 2020 Fall Te x Connect X 5 ACC 3202 Syllabus Fall 2020(1 x New Tab X + ezto.mheducation.com/ext/map/index.html?_con=con&external_browser=0&launchUrl=https%253A%252F%252Fnewconnect.mheducation.com%252F.. AIS Comprehensive Exam i Saved Help Save & Exit Submit |Purchase_Order_Date Date each purchase order was placed Employee_ID (FK) Unique identifier for the employee who created the 36 record Supplier_ID (FK) Unique identifier for each supplier Raw_Material_Code (FK) Unique identifier for each raw material Quantity_Purchased Quantity of each raw material purchased on the transaction 4 Raw_Material_Price Price of each raw material points 01:57:59 Supplier Table Attribute Description of Attribute Supplier_ID (PK) Unique identifier for each supplier Business_Name The name of the supplier eBook Supplier_Address The physical street address of the supplier Supplier_City The physical city where the supplier is located Supplier_St The physical state where the supplier is located Supplier_Zip The zip code of the city where the supplier is located Employee Table Attribute Description of Attribute Employee_ID (PK) Unique identifier for each employee Last Name Last name of the employee First Name First name of the employee Email Email address of the employee Phone_Number Phone number of the employee Essay Toolbar navigation This question will be sent to your instructor for grading. Mc Graw Hill
