SQL Taskbook Level 2.10

Given a table:

order_details
id name product_count discount
1 Aaron 8 10
2 Max 4 20
3 Catherine 6 30
4 Catherine 3 50
5 Aaron 2 0

Solve the following tasks for it:

Задание 1

Find the total number of products in each order, considering only orders with more than 2 products.

Задание 2

Find orders with the maximum discount and indicate the average discount in orders.

Задание 3

Display orders with the maximum discount, in which the number of products is greater than 5, and indicate the customers who made such orders.