GCP ADP · Data Analysis and Presentation

A data practitioner is building a monthly revenue report from an orders table with a TIMESTAMP column named order_time. The current query groups rows using GROUP BY EXTRACT(MONTH FROM order_time), which combines January 2024 and January 2025 sales into a single group, producing incorrect totals for a report spanning multiple years. What change correctly groups revenue by calendar month within each year?

• AAdd ORDER BY EXTRACT(YEAR FROM order_time) after the GROUP BY clause
• BReplace EXTRACT(MONTH FROM order_time) with FORMAT_TIMESTAMP('%m', order_time)
• CAdd a WHERE clause filtering order_time to a single year before grouping
• DReplace the GROUP BY expression with TIMESTAMP_TRUNC(order_time, MONTH)