A.SELECT rank,AVG(salary)FROM people GROUP BY rank HAVING AVG(salary)>1000
B.SELECT rank,AVG(salary)FROM people HAVING AVG(salary)>1000 GROUP BY rank;
C.SELECT AVG(salary)FROM people GROUP BY rank HAVING AVG(salary)>1000;
D.SELECT rank,AVG(salary)FROM people GROUP BY rank WHERE AVG(salary)>1000;