Solutions:
Check these solutions from our community and artificial intelligence:
The solution above is optimal because it uses the GROUP BY clause to group the orders by customer_id, and then uses the AVG function to calculate the average order value for each customer.