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.

Question Timeline

See when this question was last asked and where, including any notes left by other candidates.

Company

Level

Region

Comments

Your account is free and you can post anonymously if you choose.

Hello Interview Premium

Recent interview questions

System Design Guided Practice

Exclusive content

Learn More

Leetcode 618. Students Report By Geography

Question Timeline

Comments

Questions

Learn

Links

Legal

Contact