finding max value of finishes per date : <p>Pardon for the title, but I absolutely have no idea as to how to describe this.</p>

<p>I've got a table like this:</p>

<pre><code>trackID playerID score   date
1        2       4510    1494075555
1        2       4507    1494076300
1        2       4513    1494076561
2        3       39455   1494083772
3        3       5665    1494089018
2        2       38444   1494074519
4        3       34443   1494089138
5        3       56443   1494260918
</code></pre>

<p>I want only the first finish per track, a track can have multiple players finish on the same date.
I want to have the max amount of first finishes on a single day.</p>

<p>In the table above, player 3 finished 3 maps for the first time on the 6.5.2017.
On the 8.5.2017 he only finished a single track. I only want to include the date he finished the most tracks.</p>

<p>Result I want:</p>

<pre><code>playerID trackID count(trackID)  date
3        2,3,4       3           6.5.2017
2        1,2         2           6.5.2017
</code></pre>
