title: Grouping by one column and counting from multiple columns
body: <p>I am trying to write a query on the below scenario</p>
  
  <p>Result</p>
  
  <p>Example:</p>
  
  <pre><code>ColumnA    ColumnB    
  A           B         
  B           C             
  </code></pre>
  
  <p>Result:</p>
  
  <pre><code>ColumnA   countB   countC
  A         1         0
  B         0         1
  </code></pre>