SQL Taskbook Level 2.5
Given a table:
| id | name | price | amount | category |
| 1 | Apple | 1 | 320 | Fruit |
| 2 | Fig | 2 | 100 | Fruit |
| 3 | Potato | 0.5 | 1000 | Vegetables |
| 4 | Carrot | 0.75 | 750 | Vegetables |
| 5 | Beetroot | 0.25 | 1500 | Vegetables |
Solve the following tasks for it:
List product categories and the number of products in each category.
Find the highest priced products in each category.
Find the average price of products in each category.
Find products with less than 500 units in stock.
Display products with names starting with 'B'.
