SQL Queries

a$.$ List the product lines and the average quan ty ordered for each product line.

b$.$ Write a query to display the customer name and their average payment amount

$($Payments table$)$ only if the customer$$s average amount paid is less than the average

payments of all customers. Order the results by the average payment amount from

highest to lowest.

c$.$ Write a query to display the customer name and the number of payments they have

made that is greater than their own average payment amount. Order the results by the

descending number of payments.