Question: Write a SELECT statement that returns one row for each general ledger account number that contains three columns: The account _ description column from the
Write a SELECT statement that returns one row for each general ledger account number that contains three columns:
The accountdescription column from the GeneralLedgerAccounts table
The count of the items in the InvoiceLineItems table that have the same accountnumber
The sum of the lineitemamount columns in the InvoiceLineItems table that have the same accountnumber
Return only those rows where the count of line items is greater than This should return rows. Group the result set by the accountdescription column. Sort the result set in descending sequence by the sum of the line item amounts
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
