SQL Taskbook Level 2.6
Given a table:
| id | name | price | amount | category |
| 1 | Apple | 1 | 320 | Fruit |
| 2 | Cool 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, considering only categories with products whose price is lower than the average price in their category.
Find the products with the lowest price in each category, and indicate the average number of products in these categories.
Output the average price of products in each category and the median price for each category, considering only categories with more than 3 products.
Find products with stock quantities greater than 500 units and prices lower than 1 dollars.
Display products with two-word names and prices greater than 1.5 dollars.
