Contents
Chapter 4 · DatabasePractice
← Return to textbook

CONCEPT PRACTICE

COUNT and aggregate functions: original table continuation

2 related verified questions. Take them one at a time.

Filter questions
Question sources

2 of 2 questions match.

ITPEC Practice
0/1 answered
Textbook Exercises
0/1 answered

Question 1 of 2

0/2 answered

2025 Spring · Subject A · Q21

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

Q21. Which of the following is the clause that should be inserted into blank ___A___ of the SQL statement below in order to display the total sales data for each product that sold for at least $5,000 from the table OrderDetails? OrderDetails (OrderID, ProductID, UnitPrice, Quantity) [SQL statement] SELECT ProductID, SUM(UnitPrice * Quantity) FROM OrderDetails ___A___

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

Choose your answer
Choose an option to check your answer.
1 / 2

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

Original question · Q21
Q21. Which of the following is the clause that should be inserted into blank ___A___ of the SQL statement below in order to display the total sales data for each product that sold for at least $5,000 from the table OrderDetails? OrderDetails (OrderID, ProductID, UnitPrice, Quantity) [SQL statement] SELECT ProductID, SUM(UnitPrice * Quantity) FROM OrderDetails ___A___

Scroll horizontally to read the image at full size.