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.
Assumption:
There are no duplicates in the
candidatestable.
If you are not a paid subscriber, you might not be seeing answers included in the following section.
Answer:
with helper as (select candidate_id from candidates where lower(skill) in ('python','tableau','postgresql'))
select candidate_id from helper group by candidate_id having count(*)>=3 order by candidate_id