单选题

从数据库表scores(ID, name, score1, score2)...

Question

从数据库表scores(ID, name, score1, score2)中查询ID、name，score1，score2，并是结果按照score2降序排列，下面那项SQL语句是正确的？(  )

A. SELECT * FROM scores ORDER score2 DESC

B. SELECT * FROM scores SORT 'score2' DESC

C. SELECT * FROM scores ORDER BY score2 DESC

D. SELECT * FROM scores ORDER BY 'score2' DESC