力扣SQL50 学生们参加各科测试的次数 查询 三表查询

Problem: 1280. 学生们参加各科测试的次数

👨‍🏫 参考题解

• join等价于inner join，不用关联条件的join等价于cross join

Code

select 
    stu.student_id,stu.student_name, sub.subject_name,count(e.subject_name) attended_exams
from Students stu 
join Subjects sub
left join Examinations e 
on  e.student_id = stu.student_id
And e.subject_name = sub.subject_name
group by
    stu.student_id, sub.subject_name
order by
    stu.student_id,
    sub.subject_name