A customer types mat into the search box. The search ignores capital letters, so it
must find "mat" anywhere in a product name, whatever the case. Show only products that are in
stock (stock above 0): product_id, product_name, price and stock.
End your query with ORDER BY product_id.
| products |
|---|
| product_id (PK) |
| product_name |
| category_id (FK) |
| price |
| stock |
| rating |
| is_available |
A customer types mat into the search box. The search ignores capital letters, so it
must find "mat" anywhere in a product name, whatever the case. Show only products that are in
stock (stock above 0): product_id, product_name, price and stock.
End your query with ORDER BY product_id.
| products |
|---|
| product_id (PK) |
| product_name |
| category_id (FK) |
| price |
| stock |
| rating |
| is_available |
| product_id | product_name | price | stock |
|---|---|---|---|
| 15 | Yoga Mat Pro 6mm | 999.00 | 400 |
| 21 | Basmati Rice 5kg | 749.00 | 600 |
Run query to see output