Question:

$--$ Premium customers are those customers who have placed orders with order amounts greater than the average order amount. For each customer, find the first and last names, and the order amount for all orders that exceeded the average order amount?

SELECT customer.first$\_$name, customer.last$\_$name, sum$($order$\_$line.quantity$\_$sold $*$ product.product$\_$price$)$ as Ordertotal

FROM customer, order$\_$line,product, orders

INNER JOIN orders ON orders.customer$\_$Id $=$ customer.customer$\_$id

INNER JOIN $($

SELECT order$\_$id

FROM order$\_$line

INNER JOIN product ON product.product$\_$id $=$ order$\_$line.product$\_$id

GROUP BY order$\_$id

$)$ AS orders ON orders.order$\_$id $=$ order$\_$line.order$\_$id

WHERE order$\_$line.ordertotal $>($

SELECT AVG$($SUM$($quantity$\_$sold $*$ product$\_$price$))$

FROM order$\_$line, product

INNER JOIN product ON order$\_$line.product$\_$id $=$ product.product$\_$id

GROUP BY order$\_$line.order$\_$id

$)$;