Products sold by weight or volume have their size at the end of the name, such as
"5kg", "1L" or "650ml". For the "Daily needs" shelf, find the products whose name ends with
kg, L or ml (in exactly that case) and that cost less than 1000. Show product_name and price.
End your query with ORDER BY product_id.
| products |
|---|
| product_id (PK) |
| product_name |
| category_id (FK) |
| price |
| stock |
| rating |
| is_available |
Products sold by weight or volume have their size at the end of the name, such as
"5kg", "1L" or "650ml". For the "Daily needs" shelf, find the products whose name ends with
kg, L or ml (in exactly that case) and that cost less than 1000. Show product_name and price.
End your query with ORDER BY product_id.
| products |
|---|
| product_id (PK) |
| product_name |
| category_id (FK) |
| price |
| stock |
| rating |
| is_available |
| product_name | price |
|---|---|
| Vitamin C Serum 30ml | 649.00 |
| Herbal Shampoo 650ml | 499.00 |
| Basmati Rice 5kg | 749.00 |
| Cold-Pressed Oil 1L | 329.00 |
Run query to see output