1234567891011 |
- SELECT account_description, COUNT(*) AS line_item_count,
- SUM(line_item_amount) AS line_item_amount_sum
- FROM general_ledger_accounts gl
- JOIN invoice_line_items li
- ON gl.account_number = li.account_number
- JOIN invoices i
- ON li.invoice_id = i.invoice_id
- WHERE invoice_date BETWEEN '2018-04-01' AND '2018-06-30'
- GROUP BY account_description
- HAVING line_item_count > 1
- ORDER BY line_item_amount_sum DESC
|