Practice Pinterest SQL Question | Real Coding Interviews | Hack2hire

NewThe Learning module is now liveSee what's new

Question Bank Learning

Pricing Blog Forum

Quick Summary

Identify employees whose salaries fall within the top three distinct tiers of their department.
Combine employee records with department details and apply per-group ranking logic.
Format and sort the final output according to specified column priorities.

What This Tests

Partitioning data for independent group-wise calculations.
Handling value ties without skipping subsequent rank positions.
Enriching result sets through multi-table relationships.
Filtering and ordering derived aggregate metrics.

Common Patterns

Inner Join

Window Function

Ranking

Sort

Test Cases

Input

-

Output

-

Expected

-