hql的优化,

一、求学生选的每门课都及格了的学生

select
a.*
from student2 a
join(
select b.sid
from sc2 b group by b.sid  having min(score)>60) c
on a.sid=c.sid;
两个job taken: 84.528 seconds,

select 
a.* from student2 a join sc2 b on a.sid=b.sid
group by a.sid,a.sname,a.sbirth,a.ssex
having min(b.score)>60;
1个job taken: 55.411 seconds,