Don't have Telegram yet? Try it now!
https://brianchan.us/2019/08/13/get-the-first-or-last-value-in-a-group-using-group-by-in-sql/
Get the First or Last Value in a Group Using Group By in SQL