title: SQL window function over partition by syntax error
body: <p>I have a test table with two columns brand and store</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th style="text-align: center;">brand</th>
  <th style="text-align: center;">store</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td style="text-align: center;">A</td>
  <td style="text-align: center;">a</td>
  </tr>
  <tr>
  <td style="text-align: center;">A</td>
  <td style="text-align: center;">b</td>
  </tr>
  <tr>
  <td style="text-align: center;">B</td>
  <td style="text-align: center;">a</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>I'm trying to use the window function to get the output like this</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th style="text-align: center;">brand</th>
  <th style="text-align: center;">store</th>
  <th style="text-align: center;">num_stores</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td style="text-align: center;">A</td>
  <td style="text-align: center;">a</td>
  <td style="text-align: center;">2</td>
  </tr>
  <tr>
  <td style="text-align: center;">A</td>
  <td style="text-align: center;">b</td>
  <td style="text-align: center;">2</td>
  </tr>
  <tr>
  <td style="text-align: center;">B</td>
  <td style="text-align: center;">a</td>
  <td style="text-align: center;">1</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>Here's what I've been trying on both presto sql and sqlite but keep getting &quot;(&quot; syntax error.</p>
  <pre><code>select brand, store, 
  count(store) OVER (PARTITION BY brand) as num_stores
  from table
  </code></pre>
  <p>Struggling to find why I got this error and how to fix. Appreciate your help :))</p>