The STUDENT_GRADES table has these columns: STUDENT_ID NUMBER(12) SEMESTER_END DATE GPA NUMBER(4,3) The registrar requested a report listing the students' grade point averages (GPA) sorted from highest grade point average to lowest. Which statement produces a report that displays the student ID and GPA in the sorted order requested by the registrar? ()
A. SELECT student_id, gpa FROM student_grades ORDER BY gpa ASC;
B. SELECT student_id, gpa FROM student_grades SORT ORDER BY gpa ASC;
C. SELECT student_id, gpa FROM student_grades SORT ORDER BY gpa;
D. SELECT student_id, gpa FROM student_grades ORDER BY gpa;
E. SELECT student_id, gpa FROM student_grades SORT ORDER BY gpa DESC;
F. SELECT student_id, gpa FROM student_grades ORDER BY gpa DESC
查看答案
计算机使用播放器播放电影时发不出声音,但音量调节按钮可以使用,音箱接在别人的计算机上也可以正常使用。后来打开“设备管理器”,发现声卡是Creative的,而实际主板集成的声卡是IntelAC’97的,但重新安装驱动程序后,所显示的声卡型号却没有改变,该如何解决?
第一届世界乒乓球锦标赛是在1926年举行。
A. 正确
B. 错误