Available question text
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.
Related questions
Continue with questions that share topics or the same question type.
Sources · 1 reference
These records explain where the question appears. A company tag or candidate report does not guarantee a future interview question.
Hello Interview · 1 record
No company association
Leetcode 618. Students Report By Geography
Interview date not specified · 0 source reports
Source snapshot: Nov 12, 2026
View source