Error:1248

[Sai Krishna Tummala]

Hi,

I am trying to print the number of employees, whose salary is more than the average salary of the table. empsal column consists of salaries od employees.
but i am getting Error 1248 message. pls correct the query

select count(*) as 'no.of Employees with more than avg. salary' from
(select * from Employee where empsal>(select avg(empsal) from Employee));