Sobes.tech
Intern — Middle

Getting a list of interviewers for a specific type of interview

livecode

Task condition

SELECT * FROM INTERVIEWERS WHERE id IN ( SELECT interviewer_id FROM INTERVIEWERS_INTERVIEW_TYPES WHERE interview_id IN ( SELECT id FROM INTERVIEW_TYPES WHERE name = 'Java' ) );