Write a Structured Query Language (SQL) statement based on the following statements: i) List all items...

 

Transcribed Image Text:

Write a Structured Query Language (SQL) statement based on the following statements: i) List all items that have the word 'Food' in the category name. ii) List all items with prices below RM10.00 iii) List all items with quantities between 20 and 100 iv) Find the maximum price. v) Find the minimum price. vi) Find the average price. item_id | item_name 200 Baby wipes 201 Bottle 202 Ice lemon tea 500ml 203 Crispy Nugget 204 Baked beans 205 Marina Sardine. 206 Chicken Frankfurter 207 Pepsi 1L | item_category | item_price | item_qty | Baby Baby Beverage Frozen Food Canned Food Canned Food | Frozen Food Beverage 11.9 19.9 | 1.9 | 14.9 | 3.9 5.9 4.9 3.9 | 32 12 192 32 | 40 60 | 92 55 Write a Structured Query Language (SQL) statement based on the following statements: i) List all items that have the word 'Food' in the category name. ii) List all items with prices below RM10.00 iii) List all items with quantities between 20 and 100 iv) Find the maximum price. v) Find the minimum price. vi) Find the average price. item_id | item_name 200 Baby wipes 201 Bottle 202 Ice lemon tea 500ml 203 Crispy Nugget 204 Baked beans 205 Marina Sardine. 206 Chicken Frankfurter 207 Pepsi 1L | item_category | item_price | item_qty | Baby Baby Beverage Frozen Food Canned Food Canned Food | Frozen Food Beverage 11.9 19.9 | 1.9 | 14.9 | 3.9 5.9 4.9 3.9 | 32 12 192 32 | 40 60 | 92 55

Answer rating: 100% (QA)

SQL statements for each part i To list all items with the word Food in the category name you can use ... View the full answer