title: Oracle Sql query Group by Clause
body: <p>MY_TABLE = Table with 2 columns Number, City.<br/>
  Desired Output = City and count of unique Number associated to the city. Seattle, Bellevue is part of Combined. Even though there are 4 numbers associated to Seattle, Bellevue the output is 3 as there are only 3 distinct numbers - 123, 456, 786.</p>
  
  <pre><code>  MY_TABLE
  Number   City
  123  Seattle
  456  Bellevue
  789  LosAngeles
  780  LosAngeles
  123  Bellevue
  786  Bellevue
  </code></pre>
  
  <p>Desired Output:</p>
  
  <pre><code>Combined 3
  LosAngeles 2
  </code></pre>
  
  <p>Query so far:</p>
  
  <pre><code>SELECT NUMBER, CITY FROM MY_TABLE WHERE LOOKUP_ID=100 AND CITY IN 
  ('Seattle', 'Bellevue', 'LosAngeles')
  GROUP BY NUMBER, CITY
  </code></pre>
  
  <p>Would highly appreciate if anyone provides a recommendations around the same.</p>