title: Getting error message "Incorrect syntax near '(' " when running this query
body: <p>
  Trying to create a pivot table to display the  policy name and number of customers taken each policies in the year 2000, 2001, 2004, 2005, 2006, 2008, 2010, 2012, 2015
  </p>
  
  <pre><code>Select NAME, [2000], [2001], [2004], [2005], [2006], [2008], [2010], [2012], [2015] 
    from (
            select policy.name, year(customer_policy.policy_start_date) 
              from policy 
              join customer_policy 
                on policy.id = customer_policy.policy_id 
          group by policy.name, customer_policy.policy_start_date
         ) as SourceTable
    PIVOT
        (
        count(policy.name) for year(customer_policy.policy_start_date) 
          in ([2000], [2001], [2004], [2005], [2006], [2008], [2010], [2012], [2015])
         ) As PivotTable;
  </code></pre>
  
  
  
  <p>
  I am getting:</p>
  
  <pre><code>Incorrect syntax near '(' 
  </code></pre>