Getting an error:

Error Code: $1066.$ Not unique table$/$alias: 'order$\_$line'. Please help correct the code and provide an updated query.

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

FROM customer, order$\_$line

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 order$\_$line ON order$\_$line.product$\_$id $=$ product.product$\_$id

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

$)$;