Q =  """Select sum(user_call_cnt + user_allin + user_check_cnt + user_fold_cnt + user_raise_cnt) as total_loops,
        sum(user_call_cnt)/total_loops as call_percent,
        sum(user_check_cnt)/total_loops as check_percent,
        sum(user_fold_cnt)/total_loops as fold_percent,
        sum(user_raise_cnt)/total_loops as raise_percent,
        sum(user_allin)/total_loops as allin_percent,
        avg(session_win_rate) as avg_winrate,
        max(session_win_rate) as max_winrate,
        min(session_win_rate) as min_winrate,
        stddevSamp(session_win_rate) as std_winrate,
        count() as n_matches,
        sum(user_avg_move_time)/sum(avg_move_time) as move_time,
        (avg(user_cash_end)- avg(user_cash_start))/avg(user_cash_start) as avg_delta_cash,
        avg(user_cash_start)/avg(user_chips_start) as avg_cash_to_chips,
        min(regage),
        sum(user_gift_presenter) as gift_presented,
        sum(user_respects_present) as respects_presented,
        sum(user_respects_gift) as respects_gifted,
        min(user_coins_end) as min_coins_end,
        avg(user_coins_end) as avg_coins_end,
        max(user_coins_end) as max_coins_end,
        stddevSamp(user_coins_end) as std_coins_end,
        min(user_coins_end) as min_chips_end,
        avg(user_chips_end) as avg_chips_end,
        max(user_chips_end) as max_chips_end,
        stddevSamp(user_chips_end) as std_chips_end,
        max(level),
        max(cash_paid),
        env,
        site,
        avg(avg_move_time),
        min(user_rate_by_cash) as min_user_rate_by_cash,
        avg(user_rate_by_cash) as avg_user_rate_by_cash,
        max(user_rate_by_cash) as max_user_rate_by_cash,
        stddevSamp(user_rate_by_cash) as std_user_rate_by_cash,
        avg(match_time) as avg_match_time,
        max(user_odds) as user_odds,
        avg(timeout_to_move) as timeout_to_move,
        max(tutorial) as tutorial,
        avg(user_perc_by_cash) as user_perc_by_cash,
        sum(user_msg_cnt) as user_msg_cnt,
        (sum(check_cnt)-sum(user_check_cnt))/n_matches as opponent_check,
        (sum(call_cnt)-sum(user_call_cnt))/n_matches as opponent_call,
        (sum(fold_cnt)-sum(user_fold_cnt))/n_matches as opponent_fold,
        (sum(allin_cnt)-sum(user_allin))/n_matches as opponent_allin,
        (sum(raise_cnt)-sum(user_raise_cnt))/n_matches as opponent_raise,
        sum(user_move_timeout) as user_move_timeout,
        max(user_tables) as user_tables,
        avg(table_active_players_cnt) as avg_table_active_players_cnt,
        avg(user_rate_by_chips) as avg_user_rate_by_chips,
        sum(user_allin)/(max(match_cnt) - min(match_cnt)) as allin_perc,
        avg(win_rate) as avg_win_rate_total,
        max(match_cnt) as max_match_cnt,
        min(date),
        uid, session, poker_type, game_type
        from poker_personal_game where date > '2017-10-01 00:00:00' and regdate >= '2017-10-01' and regdate <= '2017-11-01'
        group by uid, session, poker_type, game_type, env, site"""