您可以使用exists
:
select cname
from lab5comblm258.enrolled e
where exists (select 1
from lab5comblm258.class c
where c._name = e.cname and c.room = 'R128'
)
group by cname
having count(*) >= 3;
本文收集自互联网,转载请注明来源。
如有侵权,请联系 [email protected] 删除。
我来说两句