The following statement will raise an exception on which line? select dept_name, avg(all salary) ,count() “number of employees” from emp , dept where deptno = dept_no and count() > 5 group by dept_name order by 2 desc;
select dept_name, avg(all salary), count(*) “number of employees"
where deptno = dept_no
and count(*) > 5
group by dept_name
order by 2 desc;