company sql set
in
LinkedIn
LinkedIn
SQL Set
Jobs, skills, duplicate listings, hiring signals, and ranking practice for data interview fundamentals.
question list
Work through all 10 questions
Open a problem, write the query, check the expected output, then come back for the next rep.
Q01
Data Science Skills
Find candidates who have all required skills.
Q02
Duplicate Job Listings
Detect companies with duplicate job posts.
Q03
Most Active Hiring Company
Rank companies by hiring activity.
Q04
No Duplicate Listings
Return companies with clean listing behavior.
Q05
Multiple Roles
Find companies posting multiple roles.
Q06
Cross-Company Duplicates
Compare duplicate listings across companies.
Q07
Most Common Job Title
Identify the most frequent job title.
Q08
One Job Listing
Find companies with exactly one listing.
Q09
Duplicate Percentage
Calculate duplicate listing percentage.
Q10
First Job Per Company
Use ranking to find each company's first job.
