Question

用SQL查询学号为03160111的学生的所有任课老师姓名，性别

数据库包含2张表。
teachers（教师号，姓名，性别，年龄）
students(学号，教师号，成绩）

Answer 1

SELECT 姓名，性别
FROM teachers，students
WHERE students.学号 = 03160111 AND students.教师号 = teachers.教师号

Answer 2

select 姓名,性别 from teachers
where 教师号 in (
select 教师号 from students where sno=03160111
);

Answer 3

select name, sex from teachers where teachersNo in {select teachersNo form students where number = '03160111'};

Answer 4

湖南省怀化市第五中学所有老师的姓名