shopify-order-count-by-day.md

sql = <<SQL
select
  count(*),
  date_trunc('day', o.created_at) as day
from
  orders o,
  stores s
where
  o.store_id = s.id
and
  s.store_type_id = 2
and
  o.created_at > current_date - interval '10' day
group by day
SQL

ActiveRecord::Base.connection.execute(sql).to_a

Shard1: 33745 Shard2: Shard3: 32114