EXPLAIN select user_id,count(1) as cc from XXX group by user_id;
检查语法是否有问题:用EXPLAIN。
select avg(cc)
from
(
select user_id,count(1) as cc
from XXX
group by user_id
)t;
EXPLAIN select user_id,count(1) as cc from XXX group by user_id;
检查语法是否有问题:用EXPLAIN。
select avg(cc)
from
(
select user_id,count(1) as cc
from XXX
group by user_id
)t;