SQL query to print employee id and the dates they were absent : Have a table which stores the transactions of the employees id card swiped and swiped out. Columns employee id, name, swipe in date and time, swipe out date and time

How to write an SQL query that prints the employee id and dates they were absent.