Use a CTE spend with each customer_id and the total value of their orders total_spend (quantity × unit price, all statuses). Show the customer name and total_spend.
Each hint gives a little more help. Try on your own first.
Run your code to see the output here.