The inventory team wants to cut slow-moving stock, but first they need to know what's never sold. 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 |