find the number of happy hours in each shop. Also show shop id.
select shop_id, count(*) from happy_hour group by shop_id
which of them has happy hour most often?
select shop_id from happy_hour group by shop_id order by count(*) desc limit 1