Consider the following relations:

Employee$($empno$,$ ename, age, job, sal, deptno$)$

Dept$($depno$,$ dname, loc$)$

The query is to display department details which have average salary greater than the average salary of dept $30$ are:

$1.$

select emp.deptno, dname, loc from emp, dept

where dept.deptno$=$emp.deptno

group by emp.deptno dname, loc having avg$($sal$)>($select avg$($sal$)$ from emp where emp.deptno$=30)$;

select emp.deptno, dname, loc from emp, dept group by emp.deptno,dname, loc having dept.deptno$=$emp.deptno and avg$($sal$)>($select avg$($sal$)$ from emp where emp.deptno$=30)$;

select emp.deptno, dname, loc from emp join dept on dept.deptno$=$emp.deptno group by emp.deptno,dname, loc having avg$($sal$)>($select avg$($sal$)$ from emp where emp.deptno$=30)$;

IV$.$

select deptno, dname, loc from dept where deptno in $($select deptno from emp group by deptno having avg$($sal$)>($select avg$($sal$)$ from emp where emp.deptno$=30)$;

Which of the following are correct?