title: Having count in SELECT clause
body: <p>Find the names of cities that hosts both SALES and TRANSPORT departments</p>
  
  <p>For my oracle database have this table</p>
  
  <p>i.) DEPTLOC</p>
  
  <pre><code>//DEPTLOC
  CITY        DNAME
  ---------------------
  NEWYORK       IT
  NEWYORK     COMPUTER
  LONDON      Science
  LONDON      SALES
  LONDON      TRANSPORT
  </code></pre>
  
  <p>For my SQL select statement</p>
  
  <pre><code>SELECT CITY FROM DEPTLOC
  WHERE 
      DEPTLOC.DNAME='SALES' OR DEPTLOC.DNAME='TRANSPORT'
  GROUP BY
  CITY
  HAVING COUNT(*)=2;
  </code></pre>
  
  <p>the output always display </p>
  
  <pre><code>no rows selected.
  </code></pre>
  
  <p>My output should be</p>
  
  <pre><code>DNAME
  --------
  LONDON
  </code></pre>