Top 50 streamers in August 2012 - Page 2

sqlite> select log.game,sum(viewers) from log inner join dates on dates.d_id=log.d_id inner join players on players.p_id=log.p_id
 where date>"2012-04" and date<"2012-05" and log.game="SC2" and players.streamertype="Player" group by log.game;
SC2|21975553
sqlite> select log.game,sum(viewers) from log inner join dates on dates.d_id=log.d_id inner join players on players.p_id=log.p_id
 where date>"2012-05" and date<"2012-06" and log.game="SC2" and players.streamertype="Player" group by log.game;
SC2|16540003
sqlite> select log.game,sum(viewers) from log inner join dates on dates.d_id=log.d_id inner join players on players.p_id=log.p_id
 where date>"2012-06" and date<"2012-07" and log.game="SC2" and players.streamertype="Player" group by log.game;
SC2|16310764
sqlite> select log.game,sum(viewers) from log inner join dates on dates.d_id=log.d_id inner join players on players.p_id=log.p_id
 where date>"2012-07" and date<"2012-08" and log.game="SC2" and players.streamertype="Player" group by log.game;
SC2|15699150
sqlite> select log.game,sum(viewers) from log inner join dates on dates.d_id=log.d_id inner join players on players.p_id=log.p_id
 where date>"2012-08" and date<"2012-09" and log.game="SC2" and players.streamertype="Player" group by log.game;
SC2|16604833

sqlite> select events.name,avg(viewers) from log inner join events on events.e_id=log.e_id
 where events.name>"TSL4 Round" and events.name<"TSL5" and log.p_id=5642 group by log.e_id;
TSL4 Round of 32 Day 1|17457.5714285714
TSL4 Round of 32 Day 2|21978.5555555556
TSL4 Round of 32 Day 3|15957.875
TSL4 Round of 32 Day 4|23352.0454545455
TSL4 Round of 16 Sunday|13474.6315789474
TSL4 Round of 16 Monday|16443.2272727273
TSL4 Round of 8 Day 1|8554.17647058824
TSL4 Round of 8 Day 2|13729.0476190476
TSL4 Semifinals|10622.4285714286
sqlite>