title: Group by and Count(*) in Datastax Search/Solr
body: <p>Hi we have a solr index with diff fields in it like business,businessType, regionName, StateName, .....</p>
  
  <p>Now I need a solr query to get the number of business of type businessType ='event' group by regionName.</p>
  
  <p>if I want to write a sql query for this it would be <code>select region_name , Count(business) from solr where businessType='event' group by region_name</code></p>
  
  <p>Any pointer would be helpful</p>