title: Finding the max date in elastic search query
body: <p>Can you please help me to convert this sql query to elastic search query?</p>
  
  <pre><code>SELECT group,MAX(date) as max_date
  FROM table
  WHERE checks&gt;0
  GROUP BY group
  </code></pre>