Untitled
unknown
plain_text
6 months ago
250 B
0
Indexable
Never
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;