Problem Description –
Write an SQL query to report the IDs of the candidates who have at least two years of experience and the sum of the score of their interview rounds is strictly greater than
Return the result table in any order.
The query result format is in the following example.
Problem Link – Accepted Candidates
Difficulty Level – Medium
SELECT CANDIDATE_ID FROM CANDIDATES WHERE YEARS_OF_EXP >= 2 AND INTERVIEW_ID IN (SELECT INTERVIEW_ID FROM ROUNDS GROUP BY INTERVIEW_ID HAVING SUM(SCORE) > 15);