Scenario SQL Question
Fiscal Quarter Segmentation
Build mastery in Date Operations with this scenario-based SQL challenge and live execution support.
Problem Statement
Using a fiscal year that starts in April, segment 2024 fiscal-year sales by fiscal quarter (Apr–Jun = Q1 … Jan–Mar = Q4). Return fiscal_quarter, fiscal_year, total_sales — ordered by fiscal_year, fiscal_quarter.
Relevant Tables
orders
SQL Concepts Used in This Scenario
Strengthen your understanding with these targeted learning topics: