Problem Description –
Every year, each school announces a minimum score requirement that a student needs to apply to it. The school chooses the minimum score requirement based on the exam results of all the students:
- They want to ensure that even if every student meeting the requirement applies, the school can accept everyone.
- They also want to maximize the possible number of students that can apply.
- They must use a score that is in the
Write an SQL query to report the minimum score requirement for each school. If there are multiple score values satisfying the above conditions, choose the smallest one. If the input data is not enough to determine the score, report
Return the result table in any order.
The query result format is in the following example.
Problem Link – Cutoff Score
Difficulty Level – Medium
select school_id, ifnull(min(score),-1) as score from Schools left join Exam on capacity >= student_count group by school_id