title: Horizontal Count SQL
body: <p>I apologize if this is a duplicate question but I could not find my answer.</p>
  
  <p>I am trying to take data that is horizontal, and get a count of how many times a specific number appears.</p>
  
  <p>Example table</p>
  
  <pre><code>+-------+-------+-------+-------+
  | Empid | KPI_A | KPI_B | KPI_C |
  +-------+-------+-------+-------+
  |   232 |     1 |     3 |     3 |
  |   112 |     2 |     3 |     2 |
  |   143 |     3 |     1 |     1 |
  +-------+-------+-------+-------+
  </code></pre>
  
  <p>I need to see the following:</p>
  
  <pre><code>+-------+--------------+--------------+--------------+
  | EmpID | (1's Scored) | (2's Scored) | (3's Scored) |
  +-------+--------------+--------------+--------------+
  |   232 |            1 |            0 |            2 |
  |   112 |            0 |            2 |            1 |
  |   143 |            2 |            0 |            1 |
  +-------+--------------+--------------+--------------+          
  </code></pre>
  
  <p>I hope that makes sense. Any help would be appreciated.</p>