SQL employee database question

Question

Find all the employees salary records where the salary amount is greater than his/her average salary. Display employee's first name, last name, salary amount, from and to date.

Answer 1

select emp.first_name,emp.Last_name,emp.Salary,emp.FromDate,emp.Todate

from Employee emp

inner join (select First_Name,Last_Name,avg(salary) as avgsalary from Employee emp1 group by First_Name,Last_Name)avgd

on emp.First_Name=avg.First_Name and emp.Last_Name=avg.Last_Name and emp.Salary>avgd.avgsalary

Answer 2

select first_name,last_name,salary

From employees

where salary >(select avg(salary)

from employees);