+----------+-----------+--------+
| event_id | name      |  other |
+----------+-----------+--------+
| 1        | John      |  foo   |
| 2        | John      |  bar   |
| 3        | Mary      |  baz   |
| 4        | John      |  quux  |
| 5        | Kate      |  blah  |
| 6        | Mary      |  bling |
+----------+-----------+--------+

##</code><code>##

+---------------+------+
| max(event_id) | name |
+---------------+------+
|             4 | John |
|             5 | Kate |
|             6 | Mary |
+---------------+------+