Untitled
unknown
plain_text
2 years ago
127 B
0
Indexable
SELECT SUM(total),
AVG(total),
COUNT(invoice_id)
FROM invoice
WHERE billing_country = 'USA'
GROUP BY billing_city;
SELECT SUM(total),
AVG(total),
COUNT(invoice_id)
FROM invoice
WHERE billing_country = 'USA'
GROUP BY billing_city;