ITPEC Textbook
Reading settings
Theme

Guest settings stay on this device. Sign in to sync reader settings.

Contents
Chapter 4 · DatabasePractice
← Return to textbook

CONCEPT PRACTICE

Ordering grouped SQL results

1 related published questions. Take them one at a time.

Filter questions
Question sources

1 of 1 questions match.

ITPEC Practice
0/1 answered

Question 1 of 1

0/1 answered

2024 Spring · Subject A · Q21

Original exam question · Select the image to enlarge
Read the question as text

Q21. Which of the following is a clause that is inserted into blank A of the SQL statement below that calculates the average scores for each class and subject from the “MidtermTest” table and displays them in ascending order of class and subject? MidtermTest (Class, Subject, StudentNumber, Name, Score) [SQL statement] SELECT Class, Subject, AVG(Score) AS AverageScore FROM MidtermTest A

The original image above preserves the complete exam wording and layout.

Choose your answer
Choose an option to check your answer.
1 / 1Back to lesson →

Source: 2024S_FE-A_Questions.pdf, PDF page 11. ID: 2024S-A-Q021. Explanation written for this textbook.

Original question · Q21
Q21. Which of the following is a clause that is inserted into blank A of the SQL statement below that calculates the average scores for each class and subject from the “MidtermTest” table and displays them in ascending order of class and subject? MidtermTest (Class, Subject, StudentNumber, Name, Score) [SQL statement] SELECT Class, Subject, AVG(Score) AS AverageScore FROM MidtermTest A

Scroll horizontally to read the image at full size.

Figure

Open original ↗