← All practice problems

Revenue by fiscal year and fiscal quarter

working · sql🔒Walkthroughs

NEW

Revenue by fiscal year and fiscal quarter

The company's fiscal year starts February 1. So FY2025 runs Feb 2025 through Jan 2026, with fiscal Q1 = Feb-Apr, Q2 = May-Jul, Q3 = Aug-Oct, Q4 = Nov-Jan.

For each COMPLETE fiscal quarter (3 months of data present), aggregate revenue from monthly_revenue. Use the trick of shifting each month back by 1 month — calendar quarter of the shifted date IS the fiscal quarter.

Columns: fiscal_year, fiscal_quarter, revenue. Sort by fiscal_year then fiscal_quarter ascending.

Tables & sample data

monthly_revenue

Loading preview…

query.sql

Loading…

Loading editor…