The "Gifts under ₹2,000" banner needs products priced from 999 to 1999, both
included, with a rating of 4.3 or more. Show product_name, price and rating.
Cheapest first; products with the same price are sorted by product_name A–Z.
| products |
|---|
| product_id (PK) |
| product_name |
| category_id (FK) |
| price |
| stock |
| rating |
| is_available |
The "Gifts under ₹2,000" banner needs products priced from 999 to 1999, both
included, with a rating of 4.3 or more. Show product_name, price and rating.
Cheapest first; products with the same price 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 |
|---|---|---|
| Yoga Mat Pro 6mm | 999.00 | 4.3 |
| Assorted Dry Fruits 1kg | 1099.00 | 4.6 |
| Strategy Board Game | 1199.00 | 4.5 |
| Cotton Kurta - Navy | 1299.00 | 4.5 |
| Building Blocks 250pc | 1499.00 | 4.7 |
| USB-C Fast Charger 65W | 1499.00 | 4.4 |
| Mystery Thriller Box Set | 1799.00 | 4.9 |
| Cricket Bat - Kashmir | 1899.00 | 4.5 |
| Classic White Sneakers | 1999.00 | 4.4 |
Run query to see output