mysql语句查询
答案:1 悬赏:20 手机版
解决时间 2021-03-17 11:42
- 提问者网友：你给我的爱
- 2021-03-16 20:28
mysql语句查询
最佳答案
- 五星知识达人网友：撞了怀
- 2021-03-16 20:41
select t2.student_name,SUM(score) 总分
from scores t1 inner join students t2 on t1.student_id=t2.student_id
and t2.student_id in(
select t3.student_id
from scores t3,courses t4
where t3.course_id=t4.course_id
and t4.course_name='数学' and t3.score>100 )
group by t1.student_id,t2.student_name having SUM(score)>600追问t1,t2,t3,t4不用说明是哪一张表吗？
from scores t1 inner join students t2 on t1.student_id=t2.student_id
and t2.student_id in(
select t3.student_id
from scores t3,courses t4
where t3.course_id=t4.course_id
and t4.course_name='数学' and t3.score>100 )
group by t1.student_id,t2.student_name having SUM(score)>600追问t1,t2,t3,t4不用说明是哪一张表吗？
我要举报
如以上问答信息为低俗、色情、不良、暴力、侵权、涉及违法等信息，可以点下面链接进行举报！
大家都在看
推荐资讯