# $1126. 查询活跃业务
# https://leetcode-cn.com/problems/active-businesses/

# SQL架构
Create table If Not Exists Events (business_id int, event_type varchar(10), occurences int);
Truncate table Events;
insert into Events (business_id, event_type, occurences) values ('1', 'reviews', '7');
insert into Events (business_id, event_type, occurences) values ('3', 'reviews', '3');
insert into Events (business_id, event_type, occurences) values ('1', 'ads', '11');
insert into Events (business_id, event_type, occurences) values ('2', 'ads', '7');
insert into Events (business_id, event_type, occurences) values ('3', 'ads', '6');
insert into Events (business_id, event_type, occurences) values ('1', 'page views', '3');
insert into Events (business_id, event_type, occurences) values ('2', 'page views', '12');

# Write your MySQL query statement below
select
    e1.business_id
from
    Events e1
    join (
        select
            event_type,
            avg(occurences) as eventavg
        from
            Events
        group by
            event_type
    ) e2 on e1.event_type = e2.event_type
where
    e1.occurences > e2.eventavg
group by
    e1.business_id
having
    count(*) >= 2;

# clean-up
drop table Events;