Is this a Custom Query? If so, how?

Here is an example of what I need to do. This is an example of my table data:

ID. Date
1 2020-04-14
3 2020-04-13
1 2020-04-12
2 2020-04-11

Would like the following results:

ID. Most Recent Date Count
1 2020-04-14 2
3 2020-04-13 1
2 2020-04-11 1

I just can’t get my head around how to write this query?

Community Page
Last updated: