MySQL第五次作业-查询数据

1.查询教师表中教师号在T5到T10之间的所有字段数据
select * from chenminchao_teacher where NO between “T10” and “T5”;

2.查询授课表中 周数为14 的 课程号、教师号、周数、教室号 字段数据
select * from chenminchao_school_teaching where week=15;

3 查询授课表中去重后的所有教师号
select distinct teacher_no from chenminchao_school_teaching;

4.查询授课表中教室在J栋的所有字段数据，取2-3条
select * from chenminchao_school_teaching where class_num like “j%” limit 1,2;

5.查询课程表中课时数在45，30，50中的所有字段数据
select * from chenminchao_course where class_hours in(“45”,