Advanced SQL Query - 6 | LeetCode Hard 1412 | Interview Question

Script for creating table: drop table students_data, exams_data

create table students_data
(
student_id int,
student_name varchar(20)
);
insert into students_data values
(1151,'Erling'),(1152,'Wayne'),(1153,'Ram'),(1154,'Thomas'),(1155,'Sanath'), (1156,'Saeed');

create table exams_data
(
exam_id int,
student_id int,
score int);

insert into exams_data values
(101,1151,70),(101,1152,80),(101,1153,90),(201,1151,80),(301,1151,70),(301,1153,80),(301,1154,90),(401,1151,60)
,(401,1152,70),(401,1154,80),(201,1156,70);

select * from students_data
select * from exams_data