Database: coffee_shop
Question: What are the id and address of the shops which have a happy hour in May?
SQL:
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'