CREATE TABLE shop (shop_id DECIMAL, shop_name TEXT, location TEXT, open_date TEXT, open_year DECIMAL)
CREATE TABLE device (device_id DECIMAL, device TEXT, carrier TEXT, package_version TEXT, applications TEXT, software_platform TEXT)
CREATE TABLE stock (shop_id DECIMAL, device_id DECIMAL, quantity DECIMAL)

List the open date of open year of the shop named 'Apple'.
SELECT open_date, open_year FROM shop WHERE shop_name = "Apple"
SELECT "open_date", "open_year" FROM "shop" WHERE "Apple" = "shop_name"