title: MySQL Query count with multiple group per date/time
body: <p>I have following data in <code>MySQL</code> table:</p>
  
  <pre><code>+-------------------------------------+-----------------+
  |            DATE                     | SipResponseCode |
  +-------------------------------------+-----------------+
  | 20 Feb                              |             200 |
  | 20 Feb                              |             500 |
  | 20 Feb                              |             200 |
  | 20 Feb                              |             200 |
  | 20 Feb                              |             487 |
  | 20 Feb                              |             200 |
  | 20 Feb                              |             200 |
  | 20 Feb                              |             500 |
  | 20 Feb                              |             500 |
  | 20 Feb                              |             487 |
  | 20 Feb                              |             200 |
  | 20 Feb                              |             200 |
  | 20 Feb                              |             200 |
  | 20 Feb                              |             500 |
  | 20 Feb                              |             200 |
  | 20 Feb                              |             200 |
  | 20 Feb                              |             200 |
  | 20 Feb                              |             200 |
  | 20 Feb                              |             200 |
  | 20 Feb                              |             500 |
  | 21 Feb                              |             200 |
  | 21 Feb                              |             487 |
  | 21 Feb                              |             200 |
  | 21 Feb                              |             487 |
  | 21 Feb                              |             487 |
  | 21 Feb                              |             487 |
  | 21 Feb                              |             487 |
  | 21 Feb                              |             200 |
  | 21 Feb                              |             200 |
  | 21 Feb                              |             487 |
  | 21 Feb                              |             487 |
  | 21 Feb                              |             500 |
  </code></pre>
  
  <p>I want to write SQL query so it can give me count of SipResponseCode count per day <code>200</code>, <code>487</code>, <code>500</code></p>
  
  <pre><code>+-------------------------------------+------------+-----------+--------+
  |            DATE                     |    200     |    487    |   500  |
  +-------------------------------------+------------+--------------------+
  | 20 Feb                              |     14     |      2    |    5   |
  | 21 Feb                              |     4      |      7    |    1   | 
  </code></pre>
  
  <p>I have tired but cannot get correct results.</p>