For the QUERY part, you can read this article:
Specifically the part about ORDER and LIMIT.
If you want to grab a basic knowledge about it first then I have written about it here:
For the rollup column, I believe you can rollup by “Latest” using the datetime column.
Here’s the documentation:
1 Like