题目链接:点击打开链接
题目大意:略。
解题思路:略。
AC 代码
SELECT candidate_id FROM Candidates c JOIN Rounds r ON years_of_exp > 1 AND c.interview_id = r.interview_id GROUP BY candidate_id HAVING SUM(score) > 15
题目链接:点击打开链接
题目大意:略。
解题思路:略。
AC 代码
SELECT candidate_id FROM Candidates c JOIN Rounds r ON years_of_exp > 1 AND c.interview_id = r.interview_id GROUP BY candidate_id HAVING SUM(score) > 15