BigQuery SQL WHERE Date Between Current Date and -15 Days
<p>I am trying to code the following condition in the <code>WHERE</code> clause of SQL in BigQuery, but I am having difficulty with the syntax, specifically <em>date</em> math:</p>

<pre><code>WHERE date_column between current_date() and current_date() - 15 days
</code></pre>

<p>This seems easy in MySQL, but I can't get it to work with BigQuery SQL.</p>