The "Under ₹1,000" strip on the homepage shows the 5 cheapest products. A product
that isn't available (is_available is false) can't be shown. Show product_name and price.
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 "Under ₹1,000" strip on the homepage shows the 5 cheapest products. A product
that isn't available (is_available is false) can't be shown. Show product_name and price.
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 |
|---|---|
| Cold-Pressed Oil 1L | 329.00 |
| The Alchemist | 350.00 |
| Herbal Shampoo 650ml | 499.00 |
| Vitamin C Serum 30ml | 649.00 |
| Basmati Rice 5kg | 749.00 |
Run query to see output