List sales representative and the parts (with quantity) that they shipped from their home office. Order by Pno and SNAME.

List sales representative and the quantity of parts they sold in descending order by quantity.

What is the color of the parts of the same color that produced the largest total commission for this reporting period? (This aggregates all the parts of the same color)

List the total weight of all orders shipped during this reporting period. Order by weight in ascending order.

What was the color of the part that produced the largest total commission for this reporting period? (This aggregates the commission for each part and then returns the color of that part.)

Table is Parts PNO CITY Click to Add P2 P3 P4 P5 P6 PNAME Nut Bolt Screw Carriage Nail Washer COLOR WEIGHT Red Green Red Green Blue Red 12 London 17 Paris 14 London 15 Athens 12 Paris 19 London 0