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

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

---

题目链接：1280. 学生们参加各科测试的次数

代码如下：

# Write your MySQL query statement below 
select a.student_id,a.student_name,b.subject_name,count(*)-1 as attended_exams
from Students as a
right join
(
    select * from Examinations
    union all 
    select c.student_id,subject_name from Students as c join Subjects
)as b
on a.student_id=b.student_id
group by a.student_id,subject_name
order by a.student_id,subject_name