Hi good day! I have a table with name, timestamp, and type. the type is either "in" or "out". if an employee leaves the office, the guard on duty will scan their ID and tag them as "out" with timestamp. upon the employee's return, the guard will scan...