Game Database Direct SQL Access
Table Descriptions
Select avg(SoftwareWeekly.SalesLTD) FROM SoftwareWeekly, (SELECT GameID, max(SalesLTD) as SalesLTD FROM SoftwareWeekly WHERE SoftwareWeekly.Week <= '2004-01-05' GROUP BY GameID) HighSales, SoftwareInfo where SoftwareWeekly.SalesLTD = HighSales.SalesLTD and SoftwareWeekly.GameID = HighSales.GameID and SoftwareWeekly.Tracker='Famitsu' and SoftwareInfo.Platform='GCN' and SoftwareWeekly.GameID = SoftwareInfo.GameID
Connected successfully
avg(SoftwareWeekly.SalesLTD)
149580.6458
Permanent link to this query
.
Garaph