Candidate Interview Performance Analysis

Problem Statement

Candidate Interview Performance Analysis Problem Description An organization records its hiring process in three tables: candidate details, the interview rounds, and the score each candidate achieved in each round they attended. Write an SQL query that lists every candidate who meets both of these criteria: the candidate has more than 2 years of work experience ( YearsOfExp > 2 ), and the candidate's total score , the sum of their scores over all the rounds they attended, is 15 or more . For each such candidate print the ID, the name, the years of experience and the total score, in increasing order of the candidate's ID. Table: Candidates Column Type Description candidateId INTEGER Unique ID of the candidate candidateName VARCHAR(255) Name of the candidate (two candidates may share a name) YearsOfExp INTEGER Years of work experience of the candidate Table: InterviewRoundDetails Column Type Description roundId INTEGER Unique ID of the interview round roundName VARCHAR(255) Name of th