The finance team uses a fiscal calendar that begins on February 1, rather than January 1.
The monthly_revenue table contains one revenue record for each month, identified by a first-of-month date in month. Under the company's fiscal calendar:
01Fiscal Q1: February–April.
03Fiscal Q3: August–October.
04Fiscal Q4: November–January.
A fiscal year is named after the calendar year in which it begins. For example, FY2025 runs from February 2025 through January 2026.
Prepare a report showing total revenue for each complete fiscal quarter, meaning all three monthly records are present. Exclude incomplete quarters at the beginning or end of the available data.
Ordering: Sort by fiscal_year, then fiscal_quarter, both in ascending order.