思路:先用join把Students表与Subjects连接,再用count聚合
select s.student_id,s.student_name,ss.subject_name,ifnull(count(e.subject_name),0) as attended_exams
from Students s join Subjects ss
left join Examinations e on s.student_id=e.student_id and ss.subject_name=e.subject_name
group by s.student_id,s.student_name,ss.subject_name
order by s.student_id