1.通过TA表查找Tb表中平均成绩大于90分的字段wait
TA表
Tb表
结果 :select a.wait as wait, a.stu, a.`name`,b.grade from ta a, tb b where a.stu = b.stu group by b.stu having avg(grade) > 90;