SELECT count(*)::float /
   ((SELECT count(*)
    FROM cash_hand_player_statistics denominator
    WHERE denominator.id_player = 49)::float - (SELECT SUM(cc.cnt_walks)
    FROM cash_cache cc WHERE cc.id_player = 49)::float)
   as vpip
FROM cash_hand_player_statistics numerator
WHERE numerator.id_player = 49
and flg_vpip is true


PFR
SELECT count(*)::float /
((SELECT count(*)
    FROM cash_hand_player_statistics denominator
    WHERE denominator.id_player = 49)::float - (SELECT SUM(cc.cnt_walks)
    FROM cash_cache cc WHERE cc.id_player = 49)::float)
   as pfr
FROM cash_hand_player_statistics numerator
WHERE numerator.id_player = 49
and cnt_p_raise =1

SELECT   
   DISTINCT(cash_hand_summary.id_hand) as handId
FROM    cash_hand_player_statistics
JOIN    cash_hand_summary ON cash_hand_summary.id_hand = cash_hand_player_statistics.id_hand
JOIN    player ON cash_hand_player_statistics.id_player = player.id_player
JOIN    lookup_positions ON cash_hand_player_statistics.position = lookup_positions.position AND cash_hand_player_statistics.cnt_players = lookup_positions.cnt_players
JOIN    cash_limit ON cash_hand_summary.id_limit = cash_limit.id_limit
JOIN   lookup_actions as actions_p ON actions_p.id_action = cash_hand_player_statistics.id_action_p
JOIN   lookup_actions as actions_f ON actions_f.id_action = cash_hand_player_statistics.id_action_f
JOIN   lookup_actions as actions_t ON actions_t.id_action = cash_hand_player_statistics.id_action_t
JOIN   lookup_actions as actions_r ON actions_r.id_action = cash_hand_player_statistics.id_action_r
WHERE   
   TRUE
 %FILTER%

public static double[] getPreflopStats(String name, Connection con) {
         
        double[] stats = new double[6];
         
        int id_player = 1;
         
        PreparedStatement pst = null;
        ResultSet rs = null;
         
        try {
             
            // Get player ID
            String stm = "SELECT id_player FROM player WHERE player_name = ?;";
            pst = con.prepareStatement(stm);
            pst.setString(1, name);
            rs = pst.executeQuery();
 
            while (rs.next()) {
                id_player = rs.getInt(1);
            }
               
            stm = "SELECT "+
                       "( SUM(cnt_p_raise) / ( 1.0 + SUM(cnt_p_raise) + SUM(cnt_p_call) + SUM(cnt_p_fold) ) ), "+ //AFq
                       "( SUM(cnt_p_raise)*1.0 / SUM(cnt_hands) ), "+ //PFR
                       "( SUM(cnt_vpip)*1.0 / SUM(cnt_hands) ), "+ //VPIP
                       "( SUM(cnt_p_first_raise) / ( 1.0 + SUM(cnt_p_open_opp)) )  , "+//RAISEFIRST
                       "( SUM(cnt_p_3bet) / (1.0 + SUM(cnt_p_3bet_opp)) ), "+ //3BET
                       "SUM(cnt_hands) "+
                       "FROM holdem_cache WHERE id_player = ?;";
            pst = con.prepareStatement(stm);
            pst.setInt(1, id_player);
            rs = pst.executeQuery();
             
            while (rs.next()) {
                for (int i=0; i<stats.length; i++) {
                    stats[i] = rs.getDouble(i+1);   
                }
            }
             <more code here..>
        }
       
        return stats;
    }