title: combining MySQL query
body: <p>I have a query now that shows me all the calls between this time, is there a way to format it to display "day (9-5)" and "night (5-12)" in one query? </p>
  
  <pre><code>select dst, count(dst) as Day from cdr 
  WHERE lastapp='Queue' 
  AND Date(calldate) = '2012-03-23' 
  AND TIME(calldate) BETWEEN '08:00' AND '17:00' 
  GROUP BY dst;
  
  +------+-----+
  | dst  | Day |
  +------+-----+
  | 1010 |  10 |
  | 1011 |  21 |
  | 1012 |   7 |
  +------+-----+
  </code></pre>
  
  <p>What I would ideally want is this so I can grab it in an array in PHP without having to do 2 queries.</p>
  
  <pre><code>+------+-----+-------+
  | dst  | Day | Night |
  +------+-----+-------+
  | 1010 |  10 |  20   |
  | 1011 |  21 |  12   | 
  | 1012 |   7 |  4    |
  +------+-----+-------+
  </code></pre>