Homework 1

Author

Dr. Bartosiak

Coding and Database Managment

SQL - Homework 1

The following queries use the classicmodels schema. All queries use the products table.

  1. Prepare a list of products sorted by product name in descending order.

  2. List the product names and their quantity available from high to low?

  3. Report the MSRP for the products in “Vintage Cars” category?

  4. Report the product(s) with the buy price of 48.81.

  5. Report those products with the price greater than 70.

  6. Which products have product scale ratio 1:10 and 1:72?

  7. List the product names except the ones in the Planes and Ships category.

  8. Report the names of products excluding Motorcycles and Classic Cars.

  9. Report the products having MSRP greater than 110.

  10. List the product vendors in ascending alphabetical order.

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