SQL- Difference between Where, Group by and Having

Context:

You are part of the HR department at a tech company that is currently hiring for a Data Science position. To ensure that you select the best candidates for the job, you need to filter out candidates who have the essential skills required for the role. Specifically, you are looking for candidates who are proficient in 'Python', 'Tableau', and 'MySQL'.

Problem Description:

Given a list of candidates and their skills, write a SQL query to find the candidates who possess all three required skills for the Data Science position.

Note that there are no duplicates in the candidates table.
Return the result ordered by candidate_id in ascending order.

Sample Explanation:

Candidate 100 is displayed because he/she possesses all three required skills: Python, Tableau, and MySQL.
Candidates 101 and 102 are not included in the output because they are missing one or more of the required skills.

Видео SQL- Difference between Where, Group by and Having канала AllAboutData