Company: Flipkart Grid SDEintern_18july
Difficulty: hard
You are given a university placement database. Each course may be completed by multiple students, and each student may complete multiple courses. A student may also appear in multiple interviews and may receive multiple job offers. Four of the relations matter for this task: Schema courses course_id INT (PK) course_name VARCHAR domain ENUM('DSA','DBMS','OS','CN','OOPS','WEB','CLOUD','ML') enrollments student_id INT course_id INT completion_status ENUM('IN_PROGRESS','COMPLETED','DROPPED') interviews interview_id INT (PK) student_id INT (FK → students) offers offer_id INT (PK) interview_id INT (FK → interviews) offer_status ENUM('ACCEPTED','REJECTED','PENDING') Task Analyse the placement impact of courses, considering only students who completed the course. For each course report: course_id — unique ID of the course. course_name — name of the course. domai