MySQL多表查询试题(1)
–1.学生表 Student(s_id,s_name,s_birth,s_sex) –学生编号,学生姓名, 出生年月,学生性别
–2.课程表 Course(c_id,c_name,t_id) – –课程编号, 课程名称, 教师编号
–3.教师表 Teacher(t_id,t_name) –教师编号,教师姓名
–4.成绩表 Score(s_id,c_id,s_score) –学生编号,课程编号,分数
1、横向显示学生所学课程的成绩(例如:学生姓名,学生课程1的分数,学生课程2的分数)提示:子查询
select student.s_name, s.s_score as “课程1—英语”, v.s_score as “课程2-卖货”
from student
left join scores as s on student.s_id = s.s_id and s.c_id=