123456789 |
- SELECT vendor_id, COUNT(*) AS invoice_count,
- SUM(invoice_total) AS invoice_total
- FROM invoices
- GROUP BY vendor_id WITH ROLLUP;
-
- SELECT vendor_state, vendor_city, COUNT(*) AS qty_vendors
- FROM vendors
- WHERE vendor_state IN ('IA', 'NJ')
- GROUP BY vendor_state, vendor_city WITH ROLLUP;
|