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

Filtering aggregate groups with HAVING

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

2023 Autumn · Morning · Q28

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

Q28. From a “Score” table, the average score for all subjects is to be calculated for each student, and the student number and average score for students with an average score of 80 or higher are to be determined. Which of the following is the appropriate term or phrase to be entered in blank A? Here, a solid underline represents a primary key. Score (StudentNumber, Subject, Score) [SQL statement] SELECT StudentNumber, AVG(Score) FROM Score GROUP BY 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: 2023A_FE_AM_Questions.pdf, PDF page 10. ID: 2023A-AM-Q028. Explanation written for this textbook.

Original question · Q28
Q28. From a “Score” table, the average score for all subjects is to be calculated for each student, and the student number and average score for students with an average score of 80 or higher are to be determined. Which of the following is the appropriate term or phrase to be entered in blank A? Here, a solid underline represents a primary key. Score (StudentNumber, Subject, Score) [SQL statement] SELECT StudentNumber, AVG(Score) FROM Score GROUP BY A

Scroll horizontally to read the image at full size.

Figure

Open original ↗