Show product_name and price of the products that cost more than every Books
product (category_id 2) and less than at least one Electronics product (category_id 1).
End your query with ORDER BY price, product_name.
| products |
|---|
| product_id (PK) |
| product_name |
| category_id (FK) |
| price |
Show product_name and price of the products that cost more than every Books
product (category_id 2) and less than at least one Electronics product (category_id 1).
End your query with ORDER BY price, product_name.
| products |
|---|
| product_id (PK) |
| product_name |
| category_id (FK) |
| price |
| product_name | price |
|---|---|
| Cricket Bat - Kashmir | 1899.00 |
| Classic White Sneakers | 1999.00 |
| RC Stunt Car | 1999.00 |
| Steel Pressure Cooker 5L | 2199.00 |
| Denim Jacket | 2499.00 |
| Whey Protein 1kg | 2499.00 |
| Dumbbell Set 20kg | 2799.00 |
| BassBoom Headphones | 2999.00 |
| Ceramic Dinner Set (18pc) | 3499.00 |
| Air Fryer 4.5L | 8999.00 |
| Nova X5 Smartphone | 24999.00 |
| PixelTab 11 Tablet | 32999.00 |
Run query to see output