Show me information about the store named Rob Dinning?
select * from stores where store_name = "Rob Dinning"
What is the name of its marketing region?
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"