Shopify Transactions

SELECT *
FROM shopify
WHERE LEFT(COALESCE(NULLIF(Paid_at,''), NULLIF(Created_at,'')), 10)
BETWEEN '2025-07-01' AND '2025-12-31'
ORDER BY LEFT(COALESCE(NULLIF(Paid_at,''), NULLIF(Created_at,'')), 10), Name;