單項選擇題

The STUDENT_GRADES table has these columns:
STUDENT_ID NUMBER(12)
SEMESTER_END DATE
GPA NUMBER(4,3)
The register has requested a report listing the students' grade point averages (GPA), sorted from highest grade point average to lowest within each semester, starting from the earliest date. Which statement accomplishes this?（）

A.SELECT student_id, semester_end, gpa FROM student_grades ORDER BY semester_end DESC, gpa DESC;
B.SELECT student_id, semester_end, gpa FROM student_grades ORDER BY semester _end, ASC,gpa ASC;
C.SELECT student_id, semester_end, gpa FROM student_grades ORDER BY semester _end, gpa DESC;
D.SELECT student_id, semester_end, gpa FROM student_grades ORDER BY gpa DESC,semester_end DESC;
E.SELECT student_id, semester_end, gpa FROM student_grades

你可能感興趣的試題

單項選擇題

In a SELECT statement that includes a WHERE clause, where is the GROUP BY clause placed in the SELECT statement?（）

A. Immediately after the SELECT clause
B. Before the WHERE clause
C. Before the FROM clause
D. After the ORDER BY clause
E. After the WHERE clause

多項選擇題

Examine the SQL statements that creates ORDERS table:

For which columns would an index be automatically created when you execute the above SQL statement? （）

A. SER_NO
B. ORDER_ID
C. STATUS
D. PROD_ID
E. ORD_TOTAL
F. Composite index on ORDER_ID and ORDER_DATE

99色精品-9色在线-99色在线-99色视频 国产欧美日产一区二区三区_亚洲精品亚洲人成在线观看_四虎在线精品永久观看_免费一级a一片久久精

你可能感興趣的試題

In a SELECT statement that includes a WHERE clause, where is the GROUP BY clause placed in the SELECT statement?（）

Examine the SQL statements that creates ORDERS table: For which columns would an index be automatically created when you execute the above SQL statement? （）

99色精品-9色在线-99色在线-99色视频国产欧美日产一区二区三区_亚洲精品亚洲人成在线观看_四虎在线精品永久观看_免费一级a一片久久精

Examine the SQL statements that creates ORDERS table:

For which columns would an index be automatically created when you execute the above SQL statement? （）