1234567891011 |
- SELECT invoice_number, invoice_date,
- invoice_total - payment_total - credit_total AS balance_due
- FROM invoices
- WHERE invoice_total - payment_total - credit_total > 0
- AND invoice_total - payment_total - credit_total <
- (
- SELECT AVG(invoice_total - payment_total - credit_total)
- FROM invoices
- WHERE invoice_total - payment_total - credit_total > 0
- )
- ORDER BY invoice_total DESC;
|