title: Multiple nested SELECTs in SQL Query
body: <p>I'm creating a query to return one number: YTD as followed:</p>
  
  <pre><code>SELECT  TableTemp.YTD       
  FROM(   
      SELECT(( select COUNT(Items.ItemID) * 100 FROM Items WHERE Items.StatusID in (5,7,11) and year(Items.Close_Date) = 2016) / ( select COUNT(Items.ItemID)  FROM Items WHERE Items.StatusID in (5,7,11,6) and year(Items.Close_Date) = 2016)  )As YTD
  ) AS TableTemp                                                                                                           
  GROUP BY TableTemp.YTD ;
  </code></pre>
  
  <p>This works perfect, but when I add another part to return another number YTD and thisMonth:</p>
  
  <pre><code>SELECT  TableTemp.YTD  ,   TableTemp.thisMonth   
  FROM(   
  
      (select(( select COUNT(Items.ItemID) * 100 FROM Items WHERE Items.StatusID in (5,7,11) and year(Items.Close_Date) = 2016) / ( select COUNT(Items.ItemID)  FROM Items WHERE Items.StatusID in (5,7,11,6) and year(Items.Close_Date) = 2016)) As YTD,
      (select ((select COUNT(Items.ItemID) * 100 FROM Items WHERE Items.StatusID in (5,7,11) and year(Items.Close_Date) = 2016 and month(Items.Close_Date) = 11) / ( select COUNT(Items.ItemID)  FROM Items WHERE Items.StatusID in (5,7,11,6) and year(Items.Close_Date) = 2016 and month(Items.Close_Date) = 11)) As thisMonth
  ) AS TableTemp                                                                                                           
  GROUP BY TableTemp.YTD
  </code></pre>
  
  <p>Even if I simplify this to</p>
  
  <pre><code>SELECT  TableTemp.YTD  ,   TableTemp.thisMonth   
  FROM(   
  
       select COUNT(Items.ItemID) As YTD
    ,  select COUNT(Items.ItemID) As thisMonth
  ) AS TableTemp                                                                                                           
  GROUP BY TableTemp.YTD, TableTemp.thisMonth
  </code></pre>
  
  <p>I'm getting a syntax error neer select COUNT(Items.ItemID) As thisMonth</p>
  
  <p>it seems that the syntax is wrong. Any idea on how to do this? </p>