def self.overview
    select(
     "count(*) as total,
      count(distinct(user_id)) as uniques,
      coalesce(sum(credits),0) as credits,
      coalesce(round(sum(credits_usd),2),0) as gross,
      coalesce(round(sum((credits_usd) * #{APPLE_RAKE}),2),0) as net,
      coalesce(round((sum(credits_usd * #{APPLE_RAKE}) / sum(credits_usd) * 100),2),0) as difference,
      coalesce(sum(first_time_deposit),0) as ftds,
      coalesce(round(sum(CASE WHEN first_time_deposit THEN (credits_usd) ELSE 0 END),2),0) as ftd_amount
    ")
    .first
  end