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-1-1' and '2007-2-15' 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
1577118
PS2
1147341
PSP
330348
PS3
80252
Wii
51814
X360
25003
Permanent link to this query
.
Garaph