ITPEC IP October 2018 Question 27
ITPEC IP October 2018 — Question 27 of 100
A total of 120 notebooks were sold. The Products table shows that Notebook has product code S003. In Sales Details, S003 appears with quantities 40 and 80, so the required total is 40+80=120.
Answer (c)
Why not others:
- 40 and 80 are individual S003 sales rather than their total
- 200 is the sum of all products, including pencils and erasers
Key rule: Join the tables using Product_code, filter for the requested product, and sum Number_sold over all matching sales rows.
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.