The purpose of ment is to become familiar with basic SQL queries des ople ges les yllabus Quizzes Modules Conferences Collaborations Chat 1. Download the Parts Database to your computer and open the tables Information about the database In table Company, SNAME is the name of the sales representative for Cno, COMMISSION is the commission in dollars per unit of parts purchased from that salesperson and CITY is the home office of that representative. In table Parts, PNAME is the name of the part Pno, COLOR is the color the part is painted, WEIGHT is the weight of one unit of the part and CITY is the location of the warehouse for that part. The order table is a record of orders fulfilled in this reporting period. The key is Cno AND Pno. Cno is a foreign key to the company table and Pno is a foreign key to the parts table. QTY is the unit count of that order. 2. Watch the Walkthrough Video WebEx Conferences My Media 3. Create the following queries 1. List all the red parts 2. List all the orders for this reporting period by sales representative name. 3. List all the orders that were from the London warehouse. 4. List the total amount of commissions paid to each of the sales representatives during the reporting period. Order by sales representative name. 5. How much was the commission amount paid on blue parts? 4. Take a screenshot of each of the 5 SQL code and results, Paste in a word document and save as a pdf 5. Submit the pdf. 6 DatabaseFils ACCESS SQL ) Type here to search The purpose of ment is to become familiar with basic SQL queries des ople ges les yllabus Quizzes Modules Conferences Collaborations Chat 1. Download the Parts Database to your computer and open the tables Information about the database In table Company, SNAME is the name of the sales representative for Cno, COMMISSION is the commission in dollars per unit of parts purchased from that salesperson and CITY is the home office of that representative. In table Parts, PNAME is the name of the part Pno, COLOR is the color the part is painted, WEIGHT is the weight of one unit of the part and CITY is the location of the warehouse for that part. The order table is a record of orders fulfilled in this reporting period. The key is Cno AND Pno. Cno is a foreign key to the company table and Pno is a foreign key to the parts table. QTY is the unit count of that order. 2. Watch the Walkthrough Video WebEx Conferences My Media 3. Create the following queries 1. List all the red parts 2. List all the orders for this reporting period by sales representative name. 3. List all the orders that were from the London warehouse. 4. List the total amount of commissions paid to each of the sales representatives during the reporting period. Order by sales representative name. 5. How much was the commission amount paid on blue parts? 4. Take a screenshot of each of the 5 SQL code and results, Paste in a word document and save as a pdf 5. Submit the pdf. 6 DatabaseFils ACCESS SQL ) Type here to search