Homework4

Author

Dr. Bartosiak

Coding and Database Managment

SQL - Homework 4

Warning

You have to run these queries in Workbench (or Python program).

The following queries use the classicmodels schema.

Source: https://www.richardtwatson.com/

Source: https://www.richardtwatson.com/

  1. Who is at the top of organization?

  2. Who reports to directly to William Patterson?

  3. List the employees who report to those employees who report to Diane Murphy.

  4. How many employees report to the Sales Manager that is employee named ‘Bow Anthony’? Rename the column as “Mr. Bow’s Direct Reports”

  5. Find the pair of customer that have the same credit limit. Omit the customers having no credit limit (That is creditlimit = 0): Report the customer name and credit limit for each pair and be sure to avoid unnecessary duplication.

© 2025. All Rights Reserved.
Enabled by Dr. Marcin Bartosiak