title: Bigquery ORDER BY (count )
body: <p>I want to run following query into Bigquery </p>
  
  <pre><code>SELECT table1.field1, COUNT(table1.fiels2)
  FROM table1
  GROUP BY table1.fiels1
  ORDER BY COUNT(table1.fiels2)
  DESC limit 10;
  </code></pre>
  
  <p>I am getting error Error: (L1:282): expression 
      COUNT([metamx_magnetic_share.adops001.cookie], DESC) in ORDER BY is invalid</p>
  
  <p>But same query I am successfully ran on Vertica.</p>
  
  <p>Any kind of help/suggestion would be appreciated.</p>
  
  <p>Thanks </p>