1 -- count of games for the given year
\r
2 select date_part('month', create_dt), count(*)
\r
4 where date_part('year', create_dt) = 2012
\r
5 group by date_part('month', create_dt)
\r
6 order by date_part('month', create_dt);
\r
8 -- count of game types for the given year
\r
9 select game_type_cd, count(*)
\r
11 where date_part('year', create_dt) = 2012
\r
12 group by game_type_cd
\r
13 order by count(*) desc;
\r
15 -- count of unique players playing in the given month
\r
16 select date_part('month', create_dt), count(distinct player_id)
\r
17 from player_game_stats
\r
18 where date_part('year', create_dt) = 2012
\r
19 group by date_part('month', create_dt)
\r
20 order by date_part('month', create_dt);
\r
22 -- count of servers with the most games
\r
23 select servers.name, count(*)
\r
25 where servers.server_id = games.server_id
\r
26 and date_part('year', games.create_dt) = 2012
\r
27 group by servers.name
\r
28 order by count(*) desc;
\r
30 -- count of maps with the most games
\r
31 select maps.name, count(*)
\r
33 where maps.map_id = games.map_id
\r
34 and date_part('year', games.create_dt) = 2012
\r
36 order by count(*) desc;
\r
38 -- new players by month
\r
39 select date_part('month', create_dt), count(*)
\r
41 where date_part('year', create_dt) = 2012
\r
42 group by date_part('month', create_dt)
\r
43 order by date_part('month', create_dt);
\r