sqlparser · March 25, 2014 09:26
diff --git a/select as subquery b/select as subquery
  SELECT SUM (Sales) FROM Store_Information
  WHERE Store_Name IN 
         (
           SELECT Store_Name FROM Geography
           WHERE Region_Name = 'West'
         );
	SELECT SUM (Sales) FROM Store_Information
	WHERE Store_Name IN
	(
	SELECT Store_Name FROM Geography
	WHERE Region_Name = 'West'
	);