Sample table data:
+---------+---------------+------------+-----------+----------+
| TitleID | Artist | Song | Player | NumPlays |
+---------+---------------+------------+-----------+----------+
| 12345 | The foo bars | some song | player #1 | 90 |
| 12345 | The foo bars | some song | player #2 | 465 |
| 12345 | The foo bars | some song | player #3 | 741 |
| 12346 | The bar foos | song song | player #1 | 23 |
| 12346 | The bar foos | song song | player #2 | 345 |
+---------+---------------+------------+-----------+----------+
Trying to figure out a query that will get me a record set like:
+---------+---------------+------------+-----------+----------+
| TitleID | Artist | Song | Player | NumPlays |
+---------+---------------+------------+-----------+----------+
| 12345 | The foo bars | some song | player #3 | 741 |
| 12346 | The bar foos | song song | player #2 | 345 |
+---------+---------------+------------+-----------+----------+
(The name of the player with the highest number of plays for each title.)