title: Best way to break down by weeks in BigQuery
body: <p>So what I'm looking to do is create a report that shows how many sales a company had on a weekly basis.</p>
  <p>So we have a time field called <code>created</code> that looks like this:</p>
  <pre><code>2016-04-06 20:58:06 UTC
  </code></pre>
  <p>This field represents when the sale takes place.</p>
  <p>Now lets say I wanted to create a report that gives you how many sales you had on a weekly basis. So the above example will fall into something like <code>Week of 2016-04-03</code> (it doesn't have to exactly say that, I'm just going for the simplest way to do this)</p>
  <p>Anyone have any advice? I imagine it involves using the <code>UTEC_TO_xxxxxx</code> functions.</p>