MySQL ranking query

-- ------------------------------------------------------------the structure of the table ' score '--CREATE TABLE IF  not EXISTS' score ' (' ID ')int( One) not NULLauto_increment, ' name 'varchar( +) not NULL DEFAULT "', ' scores 'int( One) not NULL DEFAULT '0',  PRIMARY KEY(' id ')) ENGINE=MyISAMDEFAULTCHARSET=UTF8 auto_increment=6 ;----dump the data in the table ' score '--INSERT  into' Score ' (' id ', ' name ', ' scores ')VALUES(1,'a', the),(2,'b', -),(3,'C',98),(4,'D', the),(5,'e', the);SelectA.name, A.scores, (Select Count(ID) fromScorewhereScores>=A.scores) asMC fromScore a limit0,TenSelect *  from (SelectA.name, A.scores, (Select Count(ID) fromScorewhereScores>=A.scores) asMC fromscore a) bwhereB.mc<=TenSelect *  from(Select(Select Count(ID)+1   fromScorewhereScores>A.scores) asMc,a.name, A.scores fromScroe a) bwhereB.mc<=Ten    Order  byB.mc