Write a select statement that answers this question:
a. what is the total amount invoiced for each general ledger account number?
b. return these columns: the account number from the invoice_line_items table
c. the sum of the line item amounts from the invoice_line_items table
d. use the with rollup operator to include a row that gives the grand total.
e. this should return 22 rows. note: once you add the with rollup operator, you may need to use mysql
f. workbench’s execute sql script button instead of its execute current statement button to execute this statement.