现有student_info(学生)表,其中包括字段:stu_name(姓名,varcher型),stu_id(,int型),stu_grade(成绩,int型).现在需要查询成绩为80分的学生姓名,并且结果按照降序排列。下面查询语句正确的是( )
A.
Select stu_name from student_info where stu_grade=80 order by stu_id desc
B.
Select stu_name from student_info where stu_grade=80 order by stu_id
C.
Select stu_name from student_info where stu_grade like 80 group by stu_id
D.
Select stu_name from student_info where stu_grade=80 order by stu_id asc