Figure 4 shows the table ITEMS.

Figure 4

a) 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.

[2 Marks]

ii) List all items with prices below RM10.00

[2 Marks]

iii) List all items with quantities between 20 and 100

[2 Marks]

iv) Find the maximum price.

[2 Marks]

v) Find the minimum price.

[2 Marks]

vi) Find the average price.

| item_id | item_name | item_category | item_price | item_qty | 200 | Baby wipes | Baby 201 | Bottle | Baby 202 | Ice lemon tea 500ml | Beverage 203 | Crispy Nugget Frozen Food 204 | Baked beans Canned Food 205 | Marina Sardine | Canned Food 206 | Chicken Frankfurter Frozen Food 207 | Pepsi 1L | Beverage + 8 rows in set (0.000 sec) 11.91 19.9| 1.91 14.91 3.9 | 5.9| 4.9 | 3.9 32 | 12 192 32 40 60 92 55 |