Analytics Reporting Track · Medium · 25 min
Duplicate Job Posts
At Pinterest, analysts are preparing a operations review focused on duplicate job posts. Return the number of employers that posted the same role_name in the...
Company labels are directional practice context, not official interview guidance.
Objective
Practice query basics through a Pinterest-tagged business scenario.
Approach
Use this track to train on SQL that mirrors day-to-day analytics workflows and recurring reporting asks.
Company context
Company labels are directional practice context, not official interview guidance.
At Pinterest, analysts are preparing a operations review focused on duplicate job posts. Return the number of employers that posted the same role_name in the same city more than once during April 2024. Name the output employers_with_duplicates.
This is a Pro question
Upgrade to Pro to unlock this prompt, the SQL workspace, and all 254 problems.
Upgrade to Pro — unlock all 254 problemsSQL workspace
Run queries against the protected question data, then submit once the result shape looks right.
Sign in to run SQL
Create a free account or sign in before running queries against protected question data.