You are working with a database table that contains invoice data. The table includes columns for customer_id and total (total amount billed for each invoice). Some customers have multiple invoices. You want to find out the total amount billed to each customer, and store the result in a new column as total_amount.

Write SQL query. (Hint: add a GROUP BY clause that will group the data by customer ID number.)