Write a sql query which will give result of the city name of the employee whose avg salary > 2000

select cityname, avg(salary) as avgsal from Employee   group by cityname  having  avg(salary) >2000

Asked in many Interview questions,Many Interviews