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:
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.
Display categories with maximum discount and specify category name and maximum discount.
Display categories whose description starts with 'A' and ends with 'products'. Specify the category names.
