Game Database Direct SQL Access
Table Descriptions
select platform, sum(SalesWeekly) from SoftwareInfo a, SoftwareWeekly b where a.GameID = b.GameID and Week between '2007-12-31' and '2008-12-28' and Rank between 1 and 30 and publisher not like '%Microsoft%' and publisher not like '%Nintendo%' and publisher not like '%Pok%mon%' and publisher not like '%SCE%' group by platform order by 2 desc
Connected successfully
platform
sum(SalesWeekly)
DS
7747699
PSP
6161475
PS2
3874407
PS3
2740800
Wii
1450690
X360
717595
Permanent link to this query
.
Garaph