Game Database Direct SQL Access
Table Descriptions
select platform, sum(SalesWeekly) from SoftwareInfo a, SoftwareWeekly b where a.GameID = b.GameID and Week between '2008-01-01' and '2008-12-31' 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
7616856
PSP
6231344
PS2
3760210
PS3
2775451
Wii
1537108
X360
717595
Permanent link to this query
.
Garaph