The quality team reviews products that customers can buy (is_available is true) and that
are rated below 4.2 or not rated yet. Books (category 2) and Toys (category 8) have their
own team, so leave them out. Show product_id, product_name, category_id and rating.
End your query with ORDER BY product_id.
| products |
|---|
| product_id (PK) |
| product_name |
| category_id (FK) |
| price |
| stock |
| rating |
| is_available |
The quality team reviews products that customers can buy (is_available is true) and that
are rated below 4.2 or not rated yet. Books (category 2) and Toys (category 8) have their
own team, so leave them out. Show product_id, product_name, category_id and rating.
End your query with ORDER BY product_id.
| products |
|---|
| product_id (PK) |
| product_name |
| category_id (FK) |
| price |
| stock |
| rating |
| is_available |
| product_id | product_name | category_id | rating |
|---|---|---|---|
| 13 | Ceramic Dinner Set (18pc) | 4 | 4.0 |
| 17 | Dumbbell Set 20kg | 5 | 4.1 |
| 19 | Herbal Shampoo 650ml | 6 | 3.9 |
| 30 | Cotton Bedsheet King | 4 | 4.1 |
| 31 | Smart Desk Lamp | 1 | NULL |
Run query to see output