Revenue by Month — Solution & ExplanationProblems / Revenue by Month / EditorialApproach

Extract month: Use EXTRACT(MONTH FROM sale_date) in SQL, or F.month("sale_date") in PySpark.

Group and aggregate: Group by the extracted month. Sum amount for revenue, count rows for transaction count.

Order: Sort by month ascending.

Key ConceptDate extraction functions let you decompose date columns into components (year, month, day) for time-based aggregations.Hints

Use EXTRACT(MONTH FROM sale_date) in SQL or F.month() in PySpark.

Group by the extracted month, then aggregate with SUM and COUNT.