SQLize Online / PHPize Online  /  SQLtest Online

CREATE TABLE attendance ( id INTEGER PRIMARY KEY, employee_code varchar(20) NOT NULL, status varchar(20) NOT NULL, created timestamp NOT NULL ); 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​');