SQLize Online / PHPize Online  /  SQLtest Online

CREATE TABLE attendance ( employee_code varchar(20) NOT NULL, status varchar(20) NOT NULL, timr timestamp ); INSERT INTO attendance VALUES ('EMP0001', 'check_in', '2021-11-22 08:00:00'), ('EMP0002', 'check_in', '2021-11-22 08:00:50'), ('EMP0001', 'check_out', '2021-11-22 13:00:00'), ('EMP0002', 'check_out', '2021-11-22 13:01:00'), ('EMP0001', 'check_in', '2021-11-22 13:31:00'), ('EMP0003', 'check_in', '2021-11-22 08:00:50'), ('EMP0004', 'check_in', '2021-11-22 08:01:50'), ('EMP0003', 'check_out', '2021-11-22 14:01:00'), ('EMP0004', 'check_out', '2021-11-22 14:20:00'), ('EMP0003', 'check_in', '2021-11-22 15:30:00'), ('EMP0004', 'check_in', '2021-11-22 15:31:00'), ('EMP0002', 'check_in', '2021-11-22 13:33:50'), ('EMP0001', 'check_out', '2021-11-22 18:03:00'), ('EMP0002', 'check_out', '2021-11-22 18:04:00');