salida.txt

MariaDB [attendance]> select employee_id,
    -> sum(case when status = 'presence' then 1 else 0 end) as presence_count,
    -> sum(case when status = 'absence' then 1 else 0 end) as absence_count 
    ->  from employee_attendance
    ->  group by employee_id;
+-------------+----------------+---------------+
| employee_id | presence_count | absence_count |
+-------------+----------------+---------------+
|           2 |              4 |             3 |
|           3 |              6 |             1 |
+-------------+----------------+---------------+
2 rows in set (0.000 sec)