title: MySQL Count 2 values from same field
body: <p>How can I count two different values from the same field? I have a field called Jobs and I'd like to count how many Doctors and how many Policemen in the same query.</p>
  
  <p>This is my query which counts both but returns them in the same result. I'd like to separate this result. Here is my query:</p>
  
  <pre><code>USE DBAssignmentPartC;
  SELECT Cu_City as City, Count(Cu_Job) AS TotalPoliceDoctors FROM tblCustomers
  WHERE Cu_Job = 'Doctor' OR Cu_Job = 'Policeman'
  Group by Cu_City ORDER BY TotalPoliceDoctors DESC;
  </code></pre>
  
  <p>Is it possible to still count BOTH Doctor's and Policemen and return them in their separate columns?</p>
  
  <p>I have tried searching on here and on Google but as a first year student I may be searching/using the wrong terms and I apologize if this has been answered and I've missed it.</p>
  
  <p>Thanks in advanced</p>