Can you list all the stores?
select store_name from store
Which ones have products?
select distinct t1.store_name from store as t1 join store_product as t2 on t1.store_id = t2.store_id join product as t3 on t2.product_id = t3.product_id
What products do they sell?
select t3.product from store as t1 join store_product as t2 on t1.store_id = t2.store_id join product as t3 on t2.product_id = t3.product_id
Out of those products, which ones are available at "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"