Data Science Skills LinkedIn SQL Interview Question

• Given a table of candidates and their skills, you're tasked with finding the candidates best suited for an open Data Science job.
• You want to find candidates who are proficient in Python, Tableau, and PostgreSQL.
• Write a query to list the candidates who possess all of the required skills for the job.
• Sort the output by candidate ID in ascending order.

⚠️Note:

• You have to visit the task URL to fully understand what the task needs if you want to add a solution or test your solution.

Task URL: Link

My Solution:

SELECT 
    candidate_id
FROM 
    candidates 
WHERE
    skill IN ('Python', 'Tableau', 'PostgreSQL')
GROUP BY 
    candidate_id
HAVING
    COUNT(skill) = 3;

Code Snapshot:

Learn SQL 📊

SQL 🔥 Get Expertise in SQL with These Top Free Courses💯🏆

🎥

Connect with Me 😊

🔗 Links