title: How to run a group by in AWS Cloud Watch Logs Insights
body: <p>I have CWL Entries as below. Showing entries in SQL Type for clarity</p>
  
  <pre><code>Name City
  1     Chicago
  2     Wuhan
  3     Chicago
  4     Wuhan
  5     Los Angeles
  </code></pre>
  
  <p>Now I want to get below output</p>
  
  <pre><code>City         Count
  Chicago        2
  Wuhan          2
  Los Angeles    1
  </code></pre>
  
  <p>Is there a way I can run <code>GROUP BY</code> in CWL Insights.</p>
  
  <p>Pseudo Query</p>
  
  <pre><code>Select Count(*), City From {TableName} GROUP BY City
  </code></pre>