Leetcode 618. Students Report By Geography

Aggregate student data across hierarchical geographic levels (e.g., country/state/city/school), requiring joins and multi-level grouping or conditional aggregation to produce a pivot-style report. The challenge is to correctly handle missing values and generate ordered, hierarchical summaries—typically solved with GROUP BY + CASE/conditional aggregates, ROLLUP/CUBE or window functions.