Untitled

SELECT SUM(total),
    AVG(total),
    COUNT(invoice_id)
FROM invoice
WHERE billing_country = 'USA'
GROUP BY billing_city;