รบกวนช่วยคิด query หน่อยครับ (MYSQL) ไม่น่าจะยากแต่คิดไม่ออกครับ

SELECT person_name FROM work WHERE salary > AVG(SELECT salary FROM work)

select * from tblEmployee

Go

select 
tblEmp.person_name AS EmpName,
tblEmp.company_name As CompanyName,
tblEmp.salary AS Salary,
(select AVG(salary) From tblEmployee where company_name = tblEmp.company_name Group By company_name) AS AvgOfSalary

From tblEmployee tblEmp
where tblEmp.salary > (select AVG(salary) From tblEmployee where company_name = tblEmp.company_name Group By company_name)
Group By tblEmp.person_name,tblEmp.company_name,tblEmp.salary

Go