Homework2

Author

Dr. Bartosiak

Coding and Database Managment

SQL - Homework 2

The following queries use the classicmodels schema.

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

Source: https://www.richardtwatson.com/
  1. How many unique products are in the table products?
  1. What is the total number of products and the total quantity of all products?
  1. What are the minimum and maximum prices of products?
  1. Provide the number of products by product line (hint: use group by)
  1. Report the sales representative for each customer.
  1. Report the total payments by date.
  1. Report the products that have not been sold.
  1. List the amount paid by each customer.
  1. How many orders have been placed by Herkku Gifts?
  1. Who are the employees in Boston?
  1. Report those payments greater than $100,000. Group the report by customer name. Sort the report so the customer who made the highest payment appears first.
© 2025. All Rights Reserved.
Enabled by Dr. Marcin Bartosiak