title: How to group query with count requests
body: <p>I have a table</p>
  <pre><code>IIN
  LastName
  FirstName
  MiddleName
  </code></pre>
  <p>I need to group values by IIN row, because it contains duplicates.</p>
  <p>I need table like this but without duplicates and I can't edit a table</p>
  <p><a href="https://i.stack.imgur.com/iKHAT.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/iKHAT.png" alt="enter image description here" /></a></p>
  <p>I use Microsoft SQL Server</p>