มีผลิตภัณฑ์อะไรบ้างที่ร้านค้าชื่อ 'มิรามิจิ'?ไม่จำเป็นต้องใช้ทุกโต๊ะ
What products are available at store named 'Miramichi'?It is not neccessary to use all the tables.
 store:  store_id [ VARCHAR]  store_name [ VARCHAR] 
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"