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"