Write a SQL query to join customer and order tables and return the total order amount per customer.
You are practicing as a guest. Sign up free to get your answer graded with AI feedback. Your draft stays right here.