Multi-Skill Candidate Filter

SQLEasyJunior levelLinkedIn~15 min

Problem

**[Asked at LinkedIn]**

A recruiter is filtering for candidates who are proficient in **all three** of:
Python, Tableau, and PostgreSQL.

Given a skills table where each row is one (candidate, skill) pair,
find all `candidate_id` values that possess all three required skills.
Order ascending.

Tables

Example rows — the live problem includes the full dataset.

candidate_skills

skill_id	candidate_id	skill

Expected output

Your answer should return 2 rows with the columns candidate_id.

Starter code (SQL)

SELECT *
FROM candidate_skills;

Solve this SQL question free

Write SQL and run it instantly in your browser — even on your phone. No signup needed to try.

Solve it now → Create free account

Solution & explanation

Create a free account to unlock the optimal solution, a step-by-step explanation, and the hidden test cases that grade your answer.