which shop has happy hour most frequently? List its id and number of happy hours.
create table happy_hour (shop_id varchar, PRIMARY KEY (shop_id))
select shop_id, count(*) from happy_hour group by shop_id order by count(*) desc limit 1