-- Database schema
| shop : Shop_ID [ INT ] primary_key , Address [ TEXT ] , Num_of_staff [ TEXT ] , Score [ INT ] , Open_Year [ TEXT ] | member : Member_ID [ INT ] primary_key , Name [ TEXT ] , Membership_card [ TEXT ] , Age [ INT ] , Time_of_purchase [ INT ] , Level_of_membership [ INT ] , Address [ TEXT ] | happy_hour : HH_ID [ INT ] primary_key , Shop_ID [ INT ] happy_hour.Shop_ID = shop.Shop_ID , Month [ TEXT ] , Num_of_shaff_in_charge [ INT ] | happy_hour_member : HH_ID [ INT ] primary_key , Member_ID [ INT ] happy_hour_member.Member_ID = member.Member_ID , Total_amount [ INT ] |
-- -- What are the id and address of the shops which have a happy hour in May?

SELECT t1.address ,  t1.shop_id FROM shop AS t1 JOIN happy_hour AS t2 ON t1.shop_id  =  t2.shop_id WHERE MONTH  =  'May';