title: SELECT statement in WHERE clause on BigQuery not working
body: <p>I'm trying to run the following query on Google BigQuery:</p>
  
  <pre><code>SELECT SUM(var1) AS Revenue
  FROM [table1]
  WHERE timeStamp = (SELECT MAX(timeStamp) FROM [table1])
  </code></pre>
  
  <p>I'm getting the following error:</p>
  
  <p>Error: Encountered "" at line 3, column 19. Was expecting one of:</p>
  
  <p>Is this not supported in BigQuery? If so, would there be an elegant alternative?</p>