Leetcode_1988_找出每所学校的最低分数要求_SQL

with t as (
    select s.school_id, e.score
    from schools as s left join exam as e
    on s.capacity >= e.student_count
)
select school_id, ifnull(min(score), -1) as score
from t
group by school_id