title: SQL ISSUE- Help in query count + min
body: <p>Tables:</p>
  
  <pre><code>[dbo].[Dealer]
  [number] [firstName] [surName]   [birthDate] [startWorkingDate] [ID]
  Num Dealer|full name of Dealers| birthdate | date + time       | id number
  [dbo].[Game]
  
  [gameTypeName] [gameStartDateTime] [gameEndTime] [DealerInGame]
  name of game  | date + time      | date + time| same numbers like [Dealer].[number]
  </code></pre>
  
  <p>What I want a query to do:
  query that returns the dealer (employee number and full name), who participated in the smallest amount of games.</p>
  
  <pre><code>SELECT top 1 number,firstName +' '+ surName as 'full name' FROM Dealer
  where  exists (SELECT gameTypeName,COUNT( gameTypeName)  FROM Game 
  GROUP BY gameTypeName)
  </code></pre>
  
  <p>The query only brings me the first one that has the smallest amount of games, but if there are 2 or more dealers with the same value then it doesn't show them all.</p>
  
  <p>What's wrong?</p>