环境是mysqlSELECT sname,ssex,sbirthday
FROM student
WHERE ssex = '女'
UNION
SELECT tname,tsex,tbirthday
FROM teacher
WHERE tsex = '女'
32、查询成绩比该课程平均成绩低的同学的成绩表。SELECT a.sno,a.cno,a.degree
FROM score a
LEFT JOIN (
SELECT AVG(degree) degree,cno
FROM score
GROUP BY cno)b
ON a.cno=b.cno
WHERE a.degree
SELECT Sno,Cno,degree
FROM Score a
WHERE degree
33、查询所有任课教师的Tname和Depart.SELECT tname,depart
FROM teacher
WHERE tno IN(SELECT tno FROM course )
SELECT tname,depart
FROM teacher a
WHERE EXISTS (SELECT * FROM course b WHERE a.tno=b.tno)
34、查询所有未讲课的教师的Tname和Depart.SELECT tname,depart
FROM Teacher
WHERE tno NOT IN(SELECT tno FROM course)
35、查询至少有2名男生的班号。SELECT class
FROM Student