create table si ( t_id int, s_id int ) 查询出所有老师代课的名字,和数量,条件是老师的年龄大于30,学生的年龄是大于12 貌视条件不够· create table si ( t_id int, s_id int ) 这个表代表什么具体意思?
这是teacher和student的外键表 select t.t_name from si join teacher t on si.t_id = t.t_id join student s on si.s_id = s.s_id where t.t_age > 30 and s.s_age > 12 条件不够吧?要查出代课的名字和数量,怎么看不到有关课程的table呢?
up! 这是我自己写的 insert into students values(1,'aa',22); insert into student values(2,'bb',21); insert into student values(3,'cc',24); insert into student values(4,'dd',26);
insert into teacher values(1,'a1',43); insert into teacher values(2,'b2',51); insert into teacher values(3,'