SQL Taskbook Level 3.9
Given a table:
| id | name | avg_price | avg_rating | discount |
| 1 | Tech products | 65.55 | 4.2 | 0 |
| 2 | Amazing products | 24.12 | 4.4 | 10 |
| 3 | Household products | 39.11 | 4.8 | 15 |
| 4 | Sport&Gym products | 5.99 | 4.9 | 5 |
| 5 | Books | 80.88 | 4.0 | 3 |
Solve the following tasks for it:
Задание 1
Find categories where the average price of products is higher than the average price of all products and the average rating of products in this category is higher than 4. Provide the category names.
Задание 2
Display categories with maximum discount and specify category name and maximum discount.
Задание 3
Display categories whose description starts with 'A' and ends with 'products'. Specify the category names.