# $1355. 活动参与者
# https://leetcode-cn.com/problems/activity-participants/

# SQL架构
Create table If Not Exists Friends (id int, name varchar(30), activity varchar(30));
Create table If Not Exists Activities (id int, name varchar(30));
Truncate table Friends;
insert into Friends (id, name, activity) values ('1', 'Jonathan D.', 'Eating');
insert into Friends (id, name, activity) values ('2', 'Jade W.', 'Singing');
insert into Friends (id, name, activity) values ('3', 'Victor J.', 'Singing');
insert into Friends (id, name, activity) values ('4', 'Elvis Q.', 'Eating');
insert into Friends (id, name, activity) values ('5', 'Daniel A.', 'Eating');
insert into Friends (id, name, activity) values ('6', 'Bob B.', 'Horse Riding');
Truncate table Activities;
insert into Activities (id, name) values ('1', 'Eating');
insert into Activities (id, name) values ('2', 'Singing');
insert into Activities (id, name) values ('3', 'Horse Riding');

# Write your MySQL query statement below
select
    activity
from
    Friends
group by
    activity
having
    count(*) > any(
        select
            count(*)
        from
            Friends
        group by
            activity
    )
    and count(*) < any(
        select
            count(*)
        from
            Friends
        group by
            activity
    );

# clean-up
drop table Friends;
drop table Activities;