Aggregation on a small table using window functions and ranking
Filed under Accenture
The question
Given a small table, write SQL or Spark code for a required aggregation, using window functionality and ranking.
No write-up yet. Related questions below have one.
Related Accenture questions
Collected from public candidate posts and coding forums. Updated Nov 2026.