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
Leetcode_1988_找出每所学校的最低分数要求_SQL
最新推荐文章于 2022-07-25 10:01:06 发布