I'd like to know how many staff are in charge in June?
select num_of_shaff_in_charge from happy_hour where month = "June"
How many places offer happy hour?
select count ( distinct shop_id ) from happy_hour
Can you tell me which shop ID offers the least happy hours?
select shop_id from happy_hour group by shop_id order by count ( * ) asc limit 1