Sub Select Support

[Abdul Wasie Mushtaq]

does any version of mysql support sub select
for example

for example

select deptno, ename, sal
from emp x
where sal > (select avg(sal)
from emp
where x.deptno = deptno)
order by deptno

if yes then tell me the version

thanks in advance

thank you