填空题

某数据库中有表COURSE(CNO,CNAME,TNO)、表TEACHER(TNO,TNAME,DEPART)和表SCORE(SNO,CNO,DEGREE),现要查询选修某课程的同学人数多于5人的教师姓名。请补全下列语句:
SELECT TNAME
FROM TEACHER WHERE
______
(SELECT X.TNO FROM COURSE X,TEACHER Y,SCORE Z
WHERE______
______
______
)

【参考答案】

TNO IN
X.TNO=Y.TNO AND X.CNO=Z.CNO
GROUP BY X.TNO......

(↓↓↓ 点击下方‘点击查看答案’看完整答案 ↓↓↓)