以下语句错误的是();SELECT rank, AVG(salary) FROM people HAVING AVG(salary) > 1000 GROUP BY rank;

A、SELECT rank, AVG(salary) FROM people GROUP BY rankHAVING 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 rankWHERE AVG(salary) > 1000;