CREATE TABLE store (store_id VARCHAR2, store_name VARCHAR2)
CREATE TABLE store_product (product_id VARCHAR2, store_id VARCHAR2)
CREATE TABLE product (product VARCHAR2, product_id VARCHAR2)

What products are available at store named 'Miramichi'?
SELECT t1.product FROM product AS t1 JOIN store_product AS t2 ON t1.product_id = t2.product_id JOIN store AS t3 ON t2.store_id = t3.store_id WHERE t3.store_name = "Miramichi"
SELECT "t1"."product" FROM "product" "t1" JOIN "store_product" "t2" ON "t1"."product_id" = "t2"."product_id" JOIN "store" "t3" ON "Miramichi" = "t3"."store_name" AND "t2"."store_id" = "t3"."store_id"