一、查询教师表中教师号在T5到T10之间的所有字段数据
select * from teacher where no between "t5" and "t10";
二、查询授课表中 周数为14 的 课程号、教师号、周数、教室号 字段数据
select course_no,teacher_no,week,class_num from shengdian_school_teaching where week=14;
三、查询授课表中去重后的所有教师号
select distinct teacher_no from shengdian_school_teaching;