exams 表中存放着同学们的考试记录 请用 SQL 语句,找到挂科数最多的同学所对应的 student_id
https://www.lintcode.com/problem/1932
-- Write your SQL Query here --
-- example: SELECT * FROM XX_TABLE WHERE XXX --
select student_id from
(
select sum(if(is_pass=0, 1, 0)) ct, student_id
from exams
group by student_id
having ct > 0
order by ct desc
limit 1
) t
-- Write your SQL Query here --
-- example: SELECT * FROM XX_TABLE WHERE XXX --
select student_id from
(
select sum(if(is_pass=0, 1, 0)) ct, student_id
from exams
group by student_id
having ct > 0
) t2
where ct in
(select max(ct) from
(
select sum(if(is_pass=0, 1, 0)) ct, student_id
from exams
group by student_id
having ct > 0
)t2
)