SQL Join and Window Function logic
Filed under PWC
The question
Questions included calculating record counts after joins, determining specific join types for desired results, explaining differences between rank, dense rank, and row number, and performing data manipulation tasks like filtering, adding columns, and saving as parquet.
No write-up yet. Related questions below have one.
Related PWC questions
Collected from public candidate posts and coding forums. Updated Nov 2026.