MySQL经典50题第2题

MySQL经典50题第2题

和第一题一样

-- 2、查询"01"课程比"02"课程成绩低的学生的信息及课程分数
select a.*,b.s_score as 01_sc,c.s_score as 02_sc from student a
join score b
on a.s_id = b.s_id and b.c_id = '01'
left join score c
on a.s_id = c.s_id and c.c_id = '02' where b.s_score < c.s_score;