• 2022-06-07
    以下语句错误的是()
    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;
  • 举一反三