我创建了这两个表: `GameGenre` varchar(20) NOT NULL,(`GameName`) REFERENCES `Game` (`GameName`) ON DELETE CASCADE ON UPDATE CASCADE我的查询需要基于GameScoreTotal.OverallScoreTotal从游戏表中返回前十名游戏的所有信息。我尝试过的<em
,然后在Period_rating表中也有许多条目,后者用Seclusion_ID链接到Seclusion_status表。我正在运行以下查询,以基于日期从Seclusion_Status返回一条记录,然后运行Period_rating表中与Seclusion_status记录相关的所有记录。GROUP BY period_rating.Seclusion_ID
ORDER BY Seclusion_Status.DateTimeAdde