Write a SELECT statement that returns one row for each general ledger account number that contains three columns:
1. The account_description column from the General_Ledger_Accounts table
2. The count of the entries in the Invoice_Line_Items table that have the same account_number
3. The sum of the line item amounts in the Invoice_Line_Items table that have the same account-number
Filter the result set to include only those rows with a count greater than 1; group the result set by account description; and sort the result set in descending sequence by the sum of the line item amounts.
Tables given:
general_ledger_accounts
account_number
account_description
invoice_line_items
invoice_id
invoice_sequence
account_number
line_item_amt
line_item_description