title: Combine two counts in SQLite
body: <p>I have the following table ("Table") format</p>
  
  <pre><code> A             B         C
  "801331"    "5755270"   "0"
  "1761861"   "10556391"  "1"
  "1761861"   "10557381"  "33"
  "1761861"   "11069131"  "33"
  "801331"    "24348751"  "0"
  "801331"    "77219852"  "0"
  "1761861"   "557880972" "0"
  </code></pre>
  
  <p>And I would like to count and present two different quantities in one table grouped by column A. </p>
  
  <p>The first is: </p>
  
  <pre><code>SELECT A, COUNT(*) FROM Table GROUP BY A
  </code></pre>
  
  <p>The second one has one condition:</p>
  
  <pre><code>SELECT A, COUNT(*) FROM Table WHERE C != 0 GROUP BY A
  </code></pre>
  
  <p>I want to have the following result</p>
  
  <pre><code>    A      1st  2nd
  "1761861"  "4"  "3"
  "801331"   "3"  "0"
  </code></pre>
  
  <p>I tried a few answers from questions such as <a href="https://stackoverflow.com/a/888774/2879450">thisOne</a> yet I could not make it happen as the result is one row. </p>
  
  <p>I get it is pretty easy, yet i cannot make it work. </p>
  
  <p>Is there a (simple) way to do it?</p>