Discussion on: What was your win this week?

select
  count(ip_count) as visits,
  day
from (
  select
    count(ip) as ip_count,
    created_at - (created_at % 86400) as day
  from stat
  where
    created_at >= ?
  group by ip
  order by day desc
) as stat
group by day
order by day desc

select
  count(distinct ip) as visits,
  created_at - (created_at % 86400) as day
from stat
where
  created_at >= ?
group by day
order by day desc