Untitled

unknown

plain_text

6 months ago

250 B

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;