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-1-1' and '2008-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)
PS2
525624
DS
463885
PS3
453889
PSP
389664
Wii
57335
X360
47109
Permanent link to this query
.
Garaph