- Code: Select all
select id_player, count(id_hand) as hands, substr(notes,0,3) from notes N , player P natural join holdem_hand_player_statistics S
where N.id_x = S.id_player and S.id_hand>0
group by id_player,notes
order by id_player
1;6;"T"
1;6;"B"
1;6;"F"
1;6;"-"
2;6;"T"
2;12;"-"
2;6;"F"
3;12;"-"
3;6;"F"
3;6;"T"
4;8;"-"
4;4;"F"
4;4;"T"
5;1883;"T"
5;1883;"B"
5;1883;"F"
5;1883;"W"
