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

最新推荐文章于 2024-10-17 20:40:27 发布

歪比巴卜的棒棒糖

最新推荐文章于 2024-10-17 20:40:27 发布

阅读量41

点赞数

文章标签： sql

本文链接：https://blog.csdn.net/gjvgjncg/article/details/134102101

版权

https://blog.csdn.net/heyianliunian/article/details/127645423?ops_request_misc=&request_id=&biz_id=102&utm_term=mysql%E6%95%B0%E6%8D%AE%E5%BA%93%E4%B8%A4%E4%B8%AA%E8%A1%A8%E8%BF%9E%E6%8E%A5&utm_medium=distribute.pc_search_result.none-task-blog-2~all~sobaiduweb~default-3-127645423.nonecase&spm=1018.2226.3001.4187很好的讲了两种表常用的连接方式，前几种很重要。遇到很长的题目，可以直接从输出表分析，需要对那些元素操作，需要什么条件，怎么排序，怎么筛选，怎么分组(分组条件)。

# Write your MySQL query statement below
select sd.student_id, sd.student_name, sj.subject_name, count(e.subject_name) as attended_exams
from students as sd join subjects as sj left join examinations as e
on sd.student_id = e.student_id and sj.subject_name = e.subject_name
group by sd.student_id, sj.subject_name
order by sd.student_id；