A company wants to see the attendance of its employees. The attendance list should show the present/absent count for each employee sorted by date.
This image shows my database table and my desired output table.
How may I get the output table by SQL query?
