Filter Rows based on time stamp data from access control

Hello, i have an MSSQL that i have connected in one of my flows, and in that table is a bunch of student IDCard swipe-on card reader details. The table contains the event time and ID card number, but i am trying to figure out a way i can find out the earliest event time for that ID and the last event time for that ID. What is the cleanest way to do this ?


I see, on closer look, find by min & max could work i think right