title: Counting non-zero values in sql
body: <p>I am trying to count total number of times that each individual column is greater than zero, grouped by the driver name. Right now I have;</p>
  
  <pre><code>SELECT drivername
        , COUNT(over_rpm)      AS RPMViolations
        , COUNT(over_spd)      AS SpdViolations
        , COUNT(brake_events)  AS BrakeEvents
    FROM performxbydriverdata
   WHERE  over_rpm &gt; 0
      OR over_spd &gt; 0
      OR brake_events &gt; 0
  GROUP BY drivername
  </code></pre>
  
  <p>This gives me all of the non-zero values but I get a display as:</p>
  
  <ul>
  <li>Bob Smith 62  62  62</li>
  <li>Nathan Jones 65  65  65</li>
  <li>etc.</li>
  </ul>
  
  <p>I'm trying to get a count of non-zeros in each individual values.. each violation should be grouped separately.</p>