Task 1(c) Bad Sellers
Task Description:
Express following queries in SQL!
List all products that have not been sold on 13.05.2003.
| Orders | LineItem | Product |
| Oid | Did | Date | Cid | |
| 3 | 7 | 2002-12-01 | 17 | | 5 | 11 | 2003-04-27 | 23 | | 7 | 5 | 2003-05-13 | 17 | | 10 | 5 | 2003-09-01 | 13 |
| | Oid | Pid | Amount | |
| 3 | 45 | 1 | | 3 | 67 | 5 | | 5 | 67 | 1 | | 7 | 57 | 3 | | 7 | 67 | 2 | | 10 | 45 | 2 | | 10 | 57 | 5 | | 10 | 67 | 3 |
| | Pid | Label | |
| 45 | Steckernetzteil | | 57 | TP-Kabel | | 67 | Einbaukäfig |
|
Your Result:
