下列关于SELECT短语的描述中错误的是（ ）。 A: SELECT短语中可以使用别名 B: SELECT短语中只能包含表中的列及其构成的表达式 C: SELECT短语规定了结果集中的列顺序 D: 如果FROM短语引用的两个表有同名的列，则SE LECT短语引用它们时必须使用表名前缀加以限定

以下语句错误的是() A: LECT rank, AVG(salary) FROM people HAVING AVG(salary) > 1000 GROUP BY rank; B: SELECT rank, AVG(salary) FROM people GROUP BY rank HAVING AVG(salary) > 1000 C: SELECT rank, AVG(salary) FROM people HAVING AVG(salary) > 1000 GROUP BY rank; D: SELECT AVG(salary) FROM people GROUP BY rank HAVING AVG(salary) > 1000; E: SELECT rank, AVG(salary) FROM people GROUP BY rank WHERE AVG(salary) > 1000;