点
-
-
陈革007
2020-06-15
-
nice
-
-
飞呀不死鸟
2020-06-14
-
真棒👍
-
-
fuli2020
2020-06-14
-
👍
-
-
默念641
2020-06-13
-
这么写感觉更简洁：
select stu_name,
ifnull(sum(lesson_name="语文")*score,0) 语文,
ifnull(sum(lesson_name="数学")*score,0) 数学,
ifnull(sum(lesson_name="英语")*score,0) 英语,
ifnull(sum(lesson_name="物理")*score,0) 物理,
ifnull(sum(lesson_name="化学")*score,0) 化学,
sum(score) 总分
from t_stu_profile right join t_score left join t_lesson
on t_score.lesson_id = t_lesson.lesson_id
on t_score.stu_id = t_stu_profile.stu_id
where class_id='0611' and gender="M"
group by stu_name;
-
-
liting李
2020-06-13
-
优秀
-
-
lulututu
2020-06-13
-
真棒
-
-
傅奕程
2020-06-13
-
