title: SQLite SELECT statment on one table
body: <p>I have table with colums: game-type-score-time and I want select best scores at one taype of game. And at that score I want to heve the lowest time at thet specific game,type, and score.</p>
  
  <p>I tride with group by but I didn't get what I want.</p>
  
  <pre><code>SELECT game, type, MAX(score),MIN(time)
  FROM table
  GROUP BY game,type 
  </code></pre>
  
  <p>What I want:
  If this is my table:</p>
  
  <pre><code> 0/1/0/672
   0/1/0/749
   0/1/1/2091
   0/1/1/3252
  
   0/5/0/5088
   0/5/0/5504
   0/5/1/6482
   0/5/2/9408
   0/5/2/24616
   0/5/3/6592 
   0/5/4/8706
  
   1/1/0/700
   1/1/1/1151
  
   1/5/5/4808
  
   3/1/1/1038
  </code></pre>
  
  <p>I want output like this:</p>
  
  <pre><code> 0/1/1/2091
   0/5/4/8706
   1/1/1/1151
   1/5/5/4808
   3/1/1/1038
  </code></pre>
  
  <p>What is the most eficenty way to get this result?</p>