SELECT name FROM Employee WHERE salary  >  (SELECT avg(salary) FROM Employee)
Show names for all employees with salary more than the average.
SELECT name FROM Employee WHERE salary > ( SELECT avg ( salary ) FROM Employee )
select name from employee where salary > ( select avg ( salary ) from employee )
Show names for all employees with salary more than the average .