CREATE TABLE Marketing_Regions (Marketing_Region_Name VARCHAR, Marketing_Region_Code VARCHAR)
CREATE TABLE Stores (Marketing_Region_Code VARCHAR, Store_Name VARCHAR)

What is the name of the marketing region that the store Rob Dinning belongs to?
SELECT T1.Marketing_Region_Name FROM Marketing_Regions AS T1 JOIN Stores AS T2 ON T1.Marketing_Region_Code = T2.Marketing_Region_Code WHERE T2.Store_Name = "Rob Dinning"
SELECT "T1"."Marketing_Region_Name" FROM "Marketing_Regions" AS "T1" JOIN "Stores" AS "T2" ON "Rob Dinning" = "T2"."Store_Name" AND "T1"."Marketing_Region_Code" = "T2"."Marketing_Region_Code"