在MaxCompute中通过SQL创建了一张分区表，create table t_student(name string,score bigint), 下面的SQL语句中语法正确的有:（）。
选项：

A:select * from t_student order by score limit 100;
B:select * from t_student order by score;
C:select name, score as p from t_student order by p limit 100;
D:select name, score as s from t_student order by score limit 100;