lment is to become familiar with basic SQL queries. 1. Download the Parts Database to your computer and open the tables Information about the database In table Compan ME is the name of the sales representative for Cno, COMMISSION is the commission in dollars per unit of parts purchasearom 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 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 Pho. 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. part is painted, WEIGHT is the weight of one unit 2. Watch the Walkthrough Video 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 re porting 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. DatabaseFile a Atomic Learning LTI Dropbox File Upload Google Doc LUnlnad a file lment is to become familiar with basic SQL queries. 1. Download the Parts Database to your computer and open the tables Information about the database In table Compan ME is the name of the sales representative for Cno, COMMISSION is the commission in dollars per unit of parts purchasearom 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 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 Pho. 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. part is painted, WEIGHT is the weight of one unit 2. Watch the Walkthrough Video 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 re porting 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. DatabaseFile a Atomic Learning LTI Dropbox File Upload Google Doc LUnlnad a file
