How_to_code_summary_queries/exercise 6.sql

SELECT account_number,
	SUM(line_item_amount) AS line_item_amount_sum
FROM invoice_line_items
GROUP BY account_number WITH ROLLUP;