ITPEC IP October 2020 Question 29
ITPEC IP October 2020 — Question 29 of 100
The total number of notebooks sold is 120. In the Products table, Notebook corresponds to product code S003. The Sales Details rows with S003 contain quantities 40 and 80, so their total is 40 + 80 = 120.
Answer (c)
Why not others:
- 40 and 80 each count only one of the two S003 sales rows
- 200 includes quantities belonging to other product codes
Key rule: First join or match the product name to its code, then filter sales by that code and aggregate the required quantity.
AI-generated — may contain errors
The original exam layout is preserved in the image so diagrams, formulas, tables, and code remain accurate.
This question comes from an official ITPEC past paper. ITPEC Practice is an independent study tool and is not affiliated with ITPEC. See the official IP past-paper collection or Report an issue.