CREATE TABLE district (district_id NUMBER, district_name CLOB, headquartered_city CLOB, city_population NUMBER, city_area NUMBER)
CREATE TABLE store (store_id NUMBER, store_name CLOB, type CLOB, area_size NUMBER, number_of_product_category NUMBER, ranking NUMBER)
CREATE TABLE store_product (store_id NUMBER, product_id NUMBER)
CREATE TABLE product (product_id NUMBER, product CLOB, dimensions CLOB, dpi NUMBER, pages_per_minute_color NUMBER, max_page_size CLOB, interface CLOB)
CREATE TABLE store_district (store_id NUMBER, district_id NUMBER)

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"