select as subquery demo code

select as subquery

  SELECT SUM (Sales) FROM Store_Information
  WHERE Store_Name IN 
         (
           SELECT Store_Name FROM Geography
           WHERE Region_Name = 'West'
         );