title: Elastic Search Sum aggregation with group by and where condition
body: <p>I am newbie in ElasticSearch.</p>
  
  <p>We are currently moving our code from relational DB to ElasticSearch. So we are converting our queries in ElasticSearch query format.</p>
  
  <p>I am looking for ElasticSearch equivalent of below query - </p>
  
  <pre><code>SELECT Color, SUM(ListPrice), SUM(StandardCost)
  FROM Production.Product
  WHERE Color IS NOT NULL 
      AND ListPrice != 0.00 
      AND Name LIKE 'Mountain%'
  GROUP BY Color
  </code></pre>
  
  <p>Can someone provide me the example of ElasticSearch query for above?</p>