I have a table that can be simplified as:

```
ID  |team_id |  submission file  | date     
========================================
1   |  1756  |  final_project.c  |2018-06-22 19:00:00
2   |  1923  |       asdf.c      |2018-06-22 16:00:00
3   |  1756  |     untitled.c    |2018-06-21 20:00:00
4   |  1923  |   my_project.c    |2018-06-21 14:00:00
5   |  1756  |     untitled.c    |2018-06-21 08:00:00
6   |  1814  |   my_project.c    |2018-06-20 12:00:00

```

This is a table of people submitting their projects to me, but I only want each individual students' most recent submission, with each student having a unique team\_id.

How do I recall the most recent row of each team\_id so that my recall looks like this:

```
ID  |team_id |  submission file  | date   
========================================
1   |  1756  |  final_project.c  |2018-06-22 19:00:00
2   |  1923  |       asdf.c      |2018-06-22 16:00:00
6   |  1814  |   my_project.c    |2018-06-20 12:00:00

```

Thank you for the help!