CREATE TABLE store_product (product_id VARCHAR(255), store_id VARCHAR(255)); CREATE TABLE store (store_id VARCHAR(255), store_name VARCHAR(255)); CREATE TABLE product (product VARCHAR(255), product_id VARCHAR(255))
What products are available at store named "Miramichi"?
    
SQL: 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"