title: Count who paid group by 1, 2 or 3+
body: <p>I have a payment table like the example below and I need a query that gives me how many IDs paid (AMOUNT > 0) 1 time, 2 times, 3 or more times. Example:  <br></p>
  
  <pre><code>+----+--------+
  | ID | AMOUNT |
  +----+--------+
  |  1 |     50 |
  |  1 |      0 |
  |  2 |     10 |
  |  2 |     20 |
  |  2 |     15 |
  |  2 |     10 |
  |  3 |     80 |
  +----+--------+
  </code></pre>
  
  <p>I expect the result: <br></p>
  
  <pre><code>+-----------+------------+-------------+
  | 1 payment | 2 payments | 3+ payments |
  +-----------+------------+-------------+
  |         2 |          0 |           1 |
  +-----------+------------+-------------+
  </code></pre>
  
  <p>ID 1: Paid 1 time (50). The other payment is 0, so I did not count. So, 1 person paid 1 time. </p>
  
  <p>ID 2: Paid 3 times (10,20,15). So, 1 person paid 3 or more time. </p>
  
  <p>ID 3: Paid 1 time (80). So, 2 persons paid 1 time. </p>
  
  <p>I'm doing manually on excel right now but I'm pretty sure there is a more practical solution. Any ideas?</p>