Untitled
unknown
plain_text
a year ago
250 B
1
Indexable
SELECT customer_id,
COUNT(customer_id)
FROM invoice
WHERE billing_country = 'USA'
AND CAST(invoice_date as timestamp) BETWEEN '2011-05-25' AND '2011-09-25'
GROUP BY customer_id
ORDER BY COUNT(customer_id) DESC, customer_id ASC
LIMIT 5;