为自己加油

从 student 表中查询学生姓名、年龄和成绩，结果按照年龄降序排序，年龄相同的按照成绩升序排序，下面 SQL 语句正确的是？

A.SELECT name, age, score FROM student order by age desc , score;
B.SELECT name, age, score FROM student order by age , score asc;
C.SELECT name, age, score FROM student order by 2 desc , 3 asc;
D..SELECT name, age, score FROM student order by 1 desc , 2 ;