SQL查询帮助-由于Average_Fee而无法运行

Question

我无法运行这个查询，我不知道该做什么来修复它？不会因为Average_Fee而跑。

SELECT LENGTH, AVG(RENTAL_FEE) AVERAGE_FEE
FROM MARINA_SLIP
WHERE AVERAGE_FEE < 3500
GROUP BY LENGTH
ORDER BY LENGTH DESC;

Answer 1

您需要对聚合值使用having子句。

SELECT LENGTH, AVG(RENTAL_FEE) AVERAGE_FEE
FROM MARINA_SLIP
GROUP BY LENGTH
HAVING AVERAGE_FEE < 3500
ORDER BY LENGTH DESC;