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

{ Published by chandrasekhar - On 6:04 PM - 0 comments }
select cityname, avg(salary) as avgsal from Employee   group by cityname  having  avg(salary) >2000

Asked in many Interview questions,Many Interviews