如何修复。
select activity from ( Select activity, count(*) as count from FRIENDS group by activity) as getActivities
where count not in
(
Select min(count) as count from (Select activity, count(*) from FRIENDS group by activity ) as maximum
union all
SELECT max(count) as count from (Select activity, count(*) from FRIENDS group by activity) as minimum
)