SELECT
  suc.n_way_test_choice_id as 239_test_groups,
  AVG(suc.cnt) as avg,
  VARIANCE(suc.cnt) as var,
  count(suc.cnt) as sample_size
FROM (
  SELECT
    nwta.n_way_test_choice_id,
    count(
      distinct(
        if(click.ds <= pi.start_date, pi.interaction_id, null)
      )
    ) as cnt
  FROM (
    SELECT distinct(user_id) as user_id
    FROM warehouse.recommendation_views rv
    WHERE rv.page='home'
      -- AND rv.platform in ('mobile_ios', 'mobile_android')
      AND substr(reverse(rv.module_id),0,1)='='
      AND rv.ds >= "2014-08-04"
      AND rv.ds <= "2014-08-12"
  ) users
  JOIN oltp.n_way_test_assignments nwta
    ON `nwta`.word_user_id = users.user_id
      AND nwta.n_way_test_choice_id in (576, 577)
  LEFT OUTER JOIN `stats`.pmp_interactions pi
    ON pi.reader_id = users.user_id
      AND pi.total_view_time >= 10
  LEFT OUTER JOIN warehouse.recommendation_clicks click
    ON click.ds >= "2014-08-04"
    AND click.ds <= "2014-08-12"
    AND click.rec_doc_id = pi.doc_id
    AND click.user_id = users.user_id
    AND click.page='home'
    -- AND click.platform in ('mobile_ios', 'mobile_android')
    AND substr(reverse(click.rec_id),0,1)='='
  GROUP BY users.user_id, nwta.n_way_test_choice_id
  HAVING cnt < 10
) suc
GROUP BY suc.n_way_test_choice_id;