Company: Headout_12sep
Difficulty: medium
Problem Description You are analyzing candidate data from an organization's hiring process. You are provided with tables containing candidate details, interview round details, and individual scores achieved by candidates in specific rounds. Write a SQL query to extract the candidates who meet specific performance and experience criteria. Schema Table: Candidates Contains background information about each candidate. candidateId (INTEGER): Unique ID for each candidate. candidateName (VARCHAR): Full name of the candidate. YearsOfExp (INTEGER): Years of professional experience. Table: InterviewRoundDetails Contains details about each interview round. roundId (INTEGER): Unique ID of the interview round. roundName (VARCHAR): Name of the interview round. roundMaxScore (INTEGER): Maximum possible score for the interview round. Table: CandidateInterviews Records the scores achieved by candidates in their respective interview rounds. interviewId (INTEGER): Unique ID of the interview record. cand