The "Customer favourites" box shows the 6 highest-rated products that cost less
than 2000. Products that haven't been rated yet must never take one of the six places. Show product_name, price and rating.
Highest rating first. Products with the same rating are sorted by product_name A–Z.
| products |
|---|
| product_id (PK) |
| product_name |
| category_id (FK) |
| price |
| stock |
| rating |
| is_available |
The "Customer favourites" box shows the 6 highest-rated products that cost less
than 2000. Products that haven't been rated yet must never take one of the six places. Show product_name, price and rating.
Highest rating first. Products with the same rating are sorted by product_name A–Z.
| products |
|---|
| product_id (PK) |
| product_name |
| category_id (FK) |
| price |
| stock |
| rating |
| is_available |
| product_name | price | rating |
|---|---|---|
| Mystery Thriller Box Set | 1799.00 | 4.9 |
| Atomic Habits | 899.00 | 4.8 |
| Building Blocks 250pc | 1499.00 | 4.7 |
| Assorted Dry Fruits 1kg | 1099.00 | 4.6 |
| The Alchemist | 350.00 | 4.6 |
| Cotton Kurta - Navy | 1299.00 | 4.5 |
Run query to see output