SELECT employee_id, attendance_date,
    CASE
        WHEN DAYOFWEEK(attendance_date) = 5 OR DAYOFWEEK(attendance_date) = 6 THEN 'Weekend'
        ELSE 'Weekday'
    END AS DayType
FROM attendance;