MySQL – Shopify count last month

✅ Option 1 — Previous calendar month only

(Example: If today is December, this returns all rows from Nov 1–Nov 30)

SELECT Lineitem_name, COUNT(*) AS count
FROM shopify
WHERE Created_at >= DATE_FORMAT(CURDATE() - INTERVAL 1 MONTH, '%Y-%m-01')
AND Created_at < DATE_FORMAT(CURDATE(), '%Y-%m-01')
GROUP BY Lineitem_name
ORDER BY count DESC;

✅ Option 2 — Last 30 days

SELECT Lineitem_name, COUNT(*) AS count
FROM shopify
WHERE Created_at >= CURDATE() - INTERVAL 30 DAY
GROUP BY Lineitem_name
ORDER BY count DESC;
Shares