更新时间:2023-12-04 12:22:52
只需将您的查询用作 AVG
的子查询,并且不要将列命名为 COUNT
保留字.
Just use your query as subquery for the AVG
, and dont name a column COUNT
that is a reserved word.
SELECT AVG(ITEM_COUNT)
FROM (
SELECT Count(*) AS ITEM_COUNT
FROM store_sales
GROUP BY ItemSize, ItemColor
) T