title: Elastic Search with group by and IN condition
body: <p>How do I can convert the following MySQL command into Elasticsearch query?</p>
  
  <pre><code>select chl_lvl2_code,chl_lvl2_nm from channel where chl_lvl1_code IN ('Retail','wholesale') group by chl_lvl2_code
  </code></pre>