Amazon marketplace vendors will likely want to know which of their products have never been ordered; if a product has never been ordered, it should be removed from the vendor's site. Using the products and order_items tables, find every product that has never appeared in any order.
Return id and name, ordered by id.
products
| column | type |
|---|---|
| id | INTEGER |
| name | TEXT |
| price | NUMERIC |
order_items
| column | type |
|---|---|
| id | INTEGER |
| order_id | INTEGER |
| product_id | INTEGER |
| quantity | INTEGER |
products
| id | name | price |
|---|---|---|
| 1 | Widget | 9.99 |
| 2 | Gadget | 24.99 |
| 3 | Gizmo | 14.99 |
| 4 | Doohickey | 4.99 |
order_items
| id | order_id | product_id | quantity |
|---|---|---|---|
| 1 | 101 | 1 | 2 |
| 2 | 102 | 1 | 1 |
| 3 | 103 | 3 | 4 |
| id | name |
|---|---|
| 2 | Gadget |
| 4 | Doohickey |