ITPEC IP October 2024 Question 26

Source exam: ITPEC IP October 2024Topic: Databases

ITPEC IP October 2024 — Question 26 of 100

Products B and C each have at least 20,000 yen in May sales, while A and D do not. Use SalesDate, join each record to Product by ProductCode, multiply quantity by price, and total the May records.

  • •A: (5 + 4) × 2,000 = 18,000 yen
  • •B: (3 + 3) × 4,000 = 24,000 yen
  • •C: 3 × 7,000 = 21,000 yen
  • •D: its sale date is April 30, so its May total is zero even though delivery occurs in May

Answer (c)

Why not others: (a) and (b) incorrectly include A, and (b) also includes D; (d) omits qualifying product B.

Key rule: Filter by the requested date field before grouping, then calculate SUM(quantity × price) for each product and apply the threshold to the group total.

AI-generated — may contain errors

The original exam layout is preserved in the image so diagrams, formulas, tables, and code remain accurate.

Practice this exam

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.