How often did you come 1st, 2nd, 3rd in poker tournaments?

Poker Copilot doesn’t tell you how often you came 1st, 2nd, or 3rd in poker tournaments. However, if you know a bit of SQL, you can use Poker Copilot’s Database Console to work this out. Here’s how:

1. From the Tools menu, select “Database Console”

2. In the database console, enter this query:

 

select
    heroranking as position, 
    count(heroranking) as count 
from 
    tournament
where 
    heroranking is not null
group by 
    heroranking
order by 
    heroranking

 

Alternatively, use this to see a histogram of sorts:

select
    heroranking as position, 
    repeat('*', count(heroranking)) as count
from 
    tournament
where 
    heroranking is not null
group by 
    heroranking
order by 
    heroranking

 

Just want to see results for places 1 to 10?

select
    heroranking as position, 
    repeat('*', count(heroranking)) as count 
from 
    tournament 
where
    heroranking <= 10 
group by 
    heroranking 
order by
    heroranking