创建一个SQL查询来检索最近的记录

I am creating a status board module for my project team. The status board allows the user to to set their status as in or out and they can also provide a note. I was planning on storing all the information in a single table ... and example of the data follows:I am creating a status board module for my proj