서브 쿼리

 

FROM절 서비 쿼리는 불가능하다. -> native 쿼리로 해결

select m
from Member m
where m.age > (select avg(m2.age) from Member m2)

select m 
from Member m
where (select count(o) from Order o where m = o.member) > 0