go.unc.edu/lbjones | Sample Queries: 01 | 03 | 04 | 06 | 07 | 09 | 11

Order Table

Raw Output

To get a listing of the books, we need to use an INNER JOIN to pull in the book titles:

The raw order table (below) needs some work... See how it is done here

Order ID Book Title Number Ordered Date Ordered Date Received Discount Price
1200502019-11-072019-11-1416.00
2148302019-11-072019-11-1421.00
314352019-11-072019-11-148.00
4689702019-11-082019-11-1427.00
554902019-11-082019-11-1423.00
689322019-11-0919.00
723212019-11-096.00
8400702019-11-1031.00
9876202019-11-1012.00
1032202019-11-1025.00