Which SQL statement returns the total Quantity per Product_ID for January 2024?

Which SQL statement returns the total Quantity per Product_ID for January 2024?

• A. SELECT Product_ID, SUM(Quantity) FROM Sales WHERE MONTH(Sales_Date) = 1 AND YEAR(Sales_Date) = 2024 GROUP BY Product_ID
• B. SELECT Product_ID, SUM(Quantity) FROM Sales WHERE Sales_Date BETWEEN '2024-01-01' AND '2024-01-31' GROUP BY Product_ID
• C. SELECT Product_ID, SUM(Quantity) FROM Sales WHERE MONTH(Sales_Date) = 1 AND YEAR(Sales_Date) = 2024 GROUP BY Product_ID
• D. SELECT Product_ID, SUM(Quantity) FROM Sales WHERE MONTH(Sales_Date) = 12 AND YEAR(Sales_Date) = 2024 GROUP BY Product_ID

Answer: (C)

The key idea is to isolate the rows that belong to January 2024, then aggregate by Product_ID to get a total Quantity for each product in that month. Filtering by the month and year extracted from the date captures every record within January 2024, regardless of the day or time, and then grouping by Product_ID with SUM(Quantity) returns the per-product totals for that month. Using a fixed date range could miss records if the Sales_Date has a time component (for example, records on January 31 after the upper bound), making it less robust. Filtering for December would not fulfill the January requirement, so it wouldn’t produce the desired results.

The key idea is to isolate the rows that belong to January 2024, then aggregate by Product_ID to get a total Quantity for each product in that month. Filtering by the month and year extracted from the date captures every record within January 2024, regardless of the day or time, and then grouping by Product_ID with SUM(Quantity) returns the per-product totals for that month. Using a fixed date range could miss records if the Sales_Date has a time component (for example, records on January 31 after the upper bound), making it less robust. Filtering for December would not fulfill the January requirement, so it wouldn’t produce the desired results.