title: SQL Pivot using count
body: <p>I have a table which has the following entries</p>
  
  <pre><code>ID | column   | value
  ------------------------
  1  | status   | DONE
  2  | status   | FAILED
  1  | progress | Green
  2  | progress | Red
  </code></pre>
  
  <p>i want the output as </p>
  
  <pre><code>ID | DONE | FAILED | GREEN | RED
  1  | 1    | 0      | 1     | 0
  2  | 0    | 1      | 0     | 1
  </code></pre>
  
  <p>Please let me know the query. I have tried pivot but not getting the results.</p>