title: Sql Select statement with different where statements
body: <p>I am trying to create a select count statement where the where statement is different for each row.<br>
  For example i got the following table called dbo.job:</p>
  
  <pre><code>User:    Job:
  Mark     Garbageman
  Dirk     Garbageman
  Henk     Garbageman
  Steven   Garbageman
  Mark     Delivery
  Dirk     Delivery
  Henk     Delivery
  Steven   Delivery
  Stevens  Delivery
  </code></pre>
  
  <p>Now i want to know how many user i got in table "job" with the job of garbageman, for this i use:</p>
  
  <pre><code>Select COUNT(user) as count from job WHERE job.job = 'Garbageman' 
  </code></pre>
  
  <p>I will get the following result:</p>
  
  <pre><code>Count:
  4
  </code></pre>
  
  <p>Now i also want to know how many users got the job of delivery in the same select statement, i will get something like:</p>
  
  <pre><code>Select COUNT(user) as GarbageCount, COUNT(user) as Deliverycount from job WHERE job.job = 'Garbageman' 
  </code></pre>
  
  <p>Now i will get the following result:</p>
  
  <pre><code>GarbageCount:   DelivryCount:
  4               4
  </code></pre>
  
  <p>But i want:</p>
  
  <p>Now i will get the following result:</p>
  
  <pre><code>GarbageCount:   DelivryCount:
  4               5
  </code></pre>
  
  <p>I know why my statement fails, that's because i am only using 1 where statement. But the where statement of both GarbageCount and DeliveryCount are different. And i have simply no clue how to create a query like that.</p>
  
  <p>Someone has any suggestions?</p>