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

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" "T1" JOIN "Stores" "T2" ON "Rob Dinning" = "T2"."Store_Name" AND "T1"."Marketing_Region_Code" = "T2"."Marketing_Region_Code"