Profiling Player Types by Poker Room+Level

Forum for users that want to write their own custom queries against the PT database either via the Structured Query Language (SQL) or using the PT3 custom stats/reports interface.

Moderator: Moderators

Profiling Player Types by Poker Room+Level

Postby T123 » Tue Aug 31, 2010 7:09 pm

Basically I want to try and build a report to understand what % of players within the player pool within my DB at a given stake are nits, tags, lags, stations, etc. No idea where to start with this... is it easily possible?

Also whats the best way to start leaning SQL? This is something I wanted to do for some time but now finally have the time to do this.

Thanks
T123
 
Posts: 135
Joined: Sun Aug 24, 2008 8:40 pm

Re: Profiling Player Types by Poker Room+Level

Postby kraada » Wed Sep 01, 2010 9:00 am

The easiest way that I can think of is to run a query against the database directly.

The query you'd want here is:
SELECT COUNT(*) from player where player.val_icon = X;

where X is the number of the icon you are looking for. The result will be the number of players with that icon.

You can run this query either from PGAdminIII or psql, both are in the PostgreSQL folder on your Start menu. I recommend starting with the PostgreSQL Tutorial - for your purposes here you don't need to pay so much attention to how databases are created (though you may find it interesting) as much as how they are queried.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY


Return to Custom Stats, Reports, and SQL [Read Only]

Who is online

Users browsing this forum: No registered users and 0 guests