title: SQL Count and group duplicates
body: <p>Please advise the best way for solving my problem.</p>
  
  <p>I have a problem figuring out how to count duplicates in table like below</p>
  
  <pre><code>Street       | City
  
  avenue 123   | New York
  avenue 123   | New York
  avenue 20    | New York
  avenue 35    | Chicago
  avenue 12    | Chicago
  avenue 123   | Chicago
  avenue 12    | Chicago
  avenue 12    | Chicago
  </code></pre>
  
  <p>I would like to have number of duplicate streets in the same City as result below?</p>
  
  <p>result:</p>
  
  <pre><code>Street     | City | Duplicates
  
  avenue 123 | New York | 2
  avenue 12  | Chicago | 3
  </code></pre>