title: Extract hour of the day from a timestamp in Big Query SQL ('FROM' error)
body: <p>I want to extract the hour of the day from the created_at timestamp (line 3) in the second column via Big Query SQL. With my current code I get the error: &quot;Encountered &quot; &quot;FROM&quot; &quot;FROM &quot;&quot; at line 3, column 18. Was expecting: &quot;)&quot; ...&quot;</p>
  <p>Current code:</p>
  <pre><code> SELECT 
      date(created_at) as date,
      EXTRACT(HOUR FROM created_at) AS hour,
      sum(net_revenue) as net_revenue, 
      count(order_unique_id) as orders  
      FROM [source]
      WHERE DATE(created_at) BETWEEN DATE(DATE_ADD(CURRENT_DATE(), -2, 'DAY')) AND CURRENT_DATE()
      GROUP BY 1,2
  </code></pre>
  <p>Thanks in advance for helping!</p>