IS 341 - Database Administration
Project #4 Solution

Homework

Most everyone got 4 of the 5 queries. #4 was the tricky one, and not everyone got it right. For this one, you needed the OrderDetails table (only), from which you select OrderID and (unitPrice * quantity), grouping by OrderID and Summing (unitPrice*quantity).

Personal Database Project

As usual, I accepted just about everything here, so long as you built something that made sense and did it properly.

Back to the top