The content team wants to prompt customers to review products they haven't rated yet. Using the products and reviews tables, find every product that has no reviews — return id and name, ordered by id.
products
| column | type |
|---|---|
| id | INTEGER |
| name | TEXT |
| category | TEXT |
| price | NUMERIC |
reviews
| column | type |
|---|---|
| id | INTEGER |
| product_id | INTEGER |
| user_id | INTEGER |
| rating | INTEGER |
| created_at | DATE |
products
| id | name | category | price |
|---|---|---|---|
| 1 | Widget | Tools | 9.99 |
| 2 | Gadget | Electronics | 149.99 |
| 3 | Gizmo | Electronics | 79.99 |
| 4 | Doohickey | Tools | 24.99 |
reviews
| id | product_id | user_id | rating | created_at |
|---|---|---|---|---|
| 1 | 1 | 101 | 5 | 2024-01-15 |
| 2 | 1 | 102 | 4 | 2024-01-20 |
| 3 | 3 | 103 | 3 | 2024-02-10 |
| id | name |
|---|---|
| 2 | Gadget |
| 4 | Doohickey |
Widget (id 1) has 2 reviews and Gizmo (id 3) has 1 review — both are excluded. Gadget and Doohickey have no reviews in the reviews table.