Please write SQL code for the following three: Display the CustomerName and the average of product price for each customer.

Please write SQL code for the following three:

1. Display the CustomerName and the average of product price for each customer.

2. Display the CustomerName who purchased products having price greater than the average of each customer purchase.

3.Display the ProductID for the product that has been sold the most (i.e., that has been sold in the highest quantity).