title: SQL Join on Multiple Matching Criterias
body: <p>Is there a way to join only one time, even though there are multiple rows with the same matching criteria? I am only wanting to join on Name and Region but want Count to be applied to only one of the rows (No specific order).</p>
  
  <p><a href="https://i.stack.imgur.com/a6TCD.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/a6TCD.png" alt="enter image description here"></a></p>