CREATE TABLE shop (address VARCHAR2, shop_id VARCHAR2)
CREATE TABLE happy_hour (shop_id VARCHAR2)

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'
SELECT "t1"."address", "t1"."shop_id" FROM "shop" "t1" JOIN "happy_hour" "t2" ON "t1"."shop_id" = "t2"."shop_id" WHERE "MONTH" = 'May'