1. How many sales reps does PSC have? Hint: I want to know how many, not who they are. Also, realize that all sales reps are employees, but not all employees are sales reps. Also, keep in mind that being a sales rep does not mean that they have actually sold anything

a. List all of the sales reps sorted by largest commission rate first Hint: name and sales commission rate

b. Who are the manager(s) of the sales reps? Hint: name of the maanaer only.

c. List the employees names who report to a Sales Manager. Hint: Your SQL statement will need to determine the manager first before it can determine the employees that report to him/her.

d. Who is the manager of the manager of the sales reps? Hint: Show the name of the sales reps managers manager only, and your single SQL statement will need to determine the sales reps manager before it can determine the manager of the sales reps manager.

e. List the employee names of those that report directly to the manager of the sales manager(s). Hint: Your SQL statement must determine the sales manager before it can determine manager of the sales reps manager, and then it must determine the names of those that report to the manager of the sales reps manager.

2. Provide an inventory report that lists the most costly items first. The inventory report should include product identification numbers, product descriptions, unit prices, supplier names, cost, and quantity supplied. Hint: the most costly item is the one in which the product of cost and quantity yields the largest value. Be careful not to confuse cost with price. Price is the value that the products are sold to the customers, and cost is the value that is paid to purchase the products from the suppliers. Also, be aware that the word product above refers to the result of multiplication (i.e., the product of cost and quantity).

3. List all of the employees in alphabetical order and each course they have completed in order of date completed. Hint: some employees might not have taken any courses.

Employeell CourseID 1 100 1 200 1 201 1 202 1 203 2 101 3 100 3 200 3 201 3 202 203 100 200 201 202 203 100 200 201 202 203 100 200 201 202 203 100 200 201 202 203 101 100 200 201 202 203 10 100 10 200 10 201 10 202 10 203 101 888 wwwcc VVVVVOOOOOUUUUUAAAAAW Course CompletionDate 2/8/2016 5/18/2016 5/19/2016 5/20/2016 5/21/2016 2/9/2012 4/22/2011 7/31/2011 8/1/2011 8/2/2011 8/3/2011 4/13/2018 7/22/2018 7/23/2018 7/24/2018 7/25/2018 6/9/2017 9/17/2017 9/18/2017 9/19/2017 9/20/2017 6/12/2014 9/20/2014 9/21/2014 9/22/2014 9/23/2014 4/30/2016 8/8/2016 8/9/2016 8/10/2016 8/11/2016 4/23/2011 6/15/2013 9/23/2013 9/24/2013 9/25/2013 9/26/2013 11/13/2016 2/21/2017 2/22/2017 2/23/2017 2/24/2017 4/2/2018 EmployeeID Employee FirstNam EmployeeLastNam EmployeeJobTitle Employee Street 1 William Medeiros SalesRep 3210 W. Parkland Blvd. 2 Michael Carboni Sales Manager 98 Waldo Ave 3 Kyle Sica SalesRep 6293 Primrose Drive 4 Louis Stein SalesRep 7707 Copper Cave 5 Christopher Demanby SalesRep 4 Magnolia Drive 6 Marlyce Bauer SalesRep 2466 24th Ave E 7 Travis Hall SalesRep 47 Moody Avenue 8 Jamie Zwolinski Sales Manager 257 Mallorca Way 9 Christopher Hudnut SalesRep 29835 Buffalo Canyon Dr 10 Magdalena Maxwell SalesRep 384 North Road 11 Bill Gates VP of Sales 123 Easy Street EmployeeCity EmployeeState EmployeeZip Employee HireDate ManagerID Tampa FL 33609 11/3/2015 1 Rochester NY 14609 6/19/2008 2 Whitestown IN 46075 1/13/2011 3 San Antonio TX 78249 1/3/2018 4 Saratoga Springs NY 12866 3/1/2017 5 Seattle WA 98112 3/3/2014 6 6 Clovis CA 93619 1/19/2016 7 7 San Francisco CA 94123 1/31/2010 8 Spring TX 77386 3/4/2013 9 Chester NJ 7930 8/1/2016 10 Portland OR 1 1/1/2018 11 ProductID SupplierID 1000 2000 3000 4000 VendorPartID 3 PWR01 1 ST001 1 STOO2 2 BD01 ProductCost Purchased Quantity $ 25,000.00 10 $ 50,000.00 30 $ 70,000.00 10 $ 40,000.00 20 StockQuantity 5.00 ProductID ProductDescription 1000 Power Generator 2000 Small Sterilizer 3000 Large Sterilizer 4000 Hospital Bed 5000 Security System UnitPrice $ 50,000.00 $ 85,000.00 $ 120,000.00 $ 70,000.00 $ 10,000.00 20.00 10.00 10.00 2.00 SupplierID SupplierName 3 GE INC. 1 LA WHOLESALE INC. 1 LA WHOLESALE INC. 2 MEDLINE SUPPLY SupplierStreet 265 PIONEER BLVD 301 HWY 167 N 301 HWY 167 N 43155 W 9 MILE RD SupplierCity SupplierState SupplierZip SPRINGBORO OH 45066 SUNSET LA 70584 SUNSET LA 70584 DETROIT MI 48375 Employeell CourseID 1 100 1 200 1 201 1 202 1 203 2 101 3 100 3 200 3 201 3 202 203 100 200 201 202 203 100 200 201 202 203 100 200 201 202 203 100 200 201 202 203 101 100 200 201 202 203 10 100 10 200 10 201 10 202 10 203 101 888 wwwcc VVVVVOOOOOUUUUUAAAAAW Course CompletionDate 2/8/2016 5/18/2016 5/19/2016 5/20/2016 5/21/2016 2/9/2012 4/22/2011 7/31/2011 8/1/2011 8/2/2011 8/3/2011 4/13/2018 7/22/2018 7/23/2018 7/24/2018 7/25/2018 6/9/2017 9/17/2017 9/18/2017 9/19/2017 9/20/2017 6/12/2014 9/20/2014 9/21/2014 9/22/2014 9/23/2014 4/30/2016 8/8/2016 8/9/2016 8/10/2016 8/11/2016 4/23/2011 6/15/2013 9/23/2013 9/24/2013 9/25/2013 9/26/2013 11/13/2016 2/21/2017 2/22/2017 2/23/2017 2/24/2017 4/2/2018 EmployeeID Employee FirstNam EmployeeLastNam EmployeeJobTitle Employee Street 1 William Medeiros SalesRep 3210 W. Parkland Blvd. 2 Michael Carboni Sales Manager 98 Waldo Ave 3 Kyle Sica SalesRep 6293 Primrose Drive 4 Louis Stein SalesRep 7707 Copper Cave 5 Christopher Demanby SalesRep 4 Magnolia Drive 6 Marlyce Bauer SalesRep 2466 24th Ave E 7 Travis Hall SalesRep 47 Moody Avenue 8 Jamie Zwolinski Sales Manager 257 Mallorca Way 9 Christopher Hudnut SalesRep 29835 Buffalo Canyon Dr 10 Magdalena Maxwell SalesRep 384 North Road 11 Bill Gates VP of Sales 123 Easy Street EmployeeCity EmployeeState EmployeeZip Employee HireDate ManagerID Tampa FL 33609 11/3/2015 1 Rochester NY 14609 6/19/2008 2 Whitestown IN 46075 1/13/2011 3 San Antonio TX 78249 1/3/2018 4 Saratoga Springs NY 12866 3/1/2017 5 Seattle WA 98112 3/3/2014 6 6 Clovis CA 93619 1/19/2016 7 7 San Francisco CA 94123 1/31/2010 8 Spring TX 77386 3/4/2013 9 Chester NJ 7930 8/1/2016 10 Portland OR 1 1/1/2018 11 ProductID SupplierID 1000 2000 3000 4000 VendorPartID 3 PWR01 1 ST001 1 STOO2 2 BD01 ProductCost Purchased Quantity $ 25,000.00 10 $ 50,000.00 30 $ 70,000.00 10 $ 40,000.00 20 StockQuantity 5.00 ProductID ProductDescription 1000 Power Generator 2000 Small Sterilizer 3000 Large Sterilizer 4000 Hospital Bed 5000 Security System UnitPrice $ 50,000.00 $ 85,000.00 $ 120,000.00 $ 70,000.00 $ 10,000.00 20.00 10.00 10.00 2.00 SupplierID SupplierName 3 GE INC. 1 LA WHOLESALE INC. 1 LA WHOLESALE INC. 2 MEDLINE SUPPLY SupplierStreet 265 PIONEER BLVD 301 HWY 167 N 301 HWY 167 N 43155 W 9 MILE RD SupplierCity SupplierState SupplierZip SPRINGBORO OH 45066 SUNSET LA 70584 SUNSET LA 70584 DETROIT MI 48375