Write a Query to display employees getting salary greater that average salary

Query 1;

select  empno, ename, job, mgr,sal,hiredate,comm, deptno,avg_sal

 from 

 (select empno, ename, job, mgr,sal,hiredate,comm, deptno,avg(sal) over(partition by deptno) avg_sal from emp) where sal>avg_sal;

 Query 2:

select * from emp a,(select deptno,avg(sal) sal from emp group by deptno) b

 where a.deptno=b.deptno and a.sal>b.sal;