title: Get order count of employees, which have different count than in one city
body: <p>SQL studying is going good speed forward. Now got practice where I need some help.</p>
  
  <p>I would like to get names of the employees who have different count of orders than employees in New York.</p>
  
  <p>Tables:</p>
  
  <p><code>ORDERS</code>, which including <code>EMPLOYEE_ID, CITY, ORDER_ID</code></p>
  
  <p><code>EMPLOYEES</code>, which including <code>LAST_NAME, FIRST_NAME, EMPLOYEE_ID, CITY</code></p>
  
  <p>I have been stuck in this situation:</p>
  
  <pre><code>SELECT ROW_NUMBER() OVER ( ORDER BY COUNT(T.ORDER_ID) DESC) ROW,
  (H.LAST_NAME + ', ' + H.FIRST_NAME) 'Employee name',
  COUNT(T.ORDER_ID) 'Sold orders', H.CITY 'City'
  
  FROM ORDERS T JOIN EMPLOYEE H ON T.EMPLOYEE_ID = H.EMPLOYEE_ID
  
  GROUP BY H.EMPLOYEE_ID, H.LAST_NAME, H.FIRST_NAME, H.CITY
  </code></pre>
  
  <p>With that I can get orders which employees has sold. Unfortunately it does not show employees with 0 orders. </p>
  
  <p>How I can show also employees with 0 orders? And how can I show employees who have different count of orders than employees in one city? Example employees which have different order coutn than employees in New York.</p>
  
  <p>I hope you understand what I mean. Complicated problem and little language barrier.</p>
  
  <p>Example data:</p>
  
  <pre><code>First_name    Last_name    Sold_orders    City
  John          Doe          2              New York
  Jane          Doe          5              Los Angeles
  Peter         Pan          5              Miami
  </code></pre>
  
  <p>I would like to get employees which do not have same count of orders than employees in Miami.</p>
  
  <pre><code>First_name    Last_name    Sold_orders    City
  John          Doe          2              New York
  </code></pre>
  
  <p>So Jane doe and Peter Pan has gone, because they have same count of orders than employees in Miami (Miami itself included).</p>