SELECT
CASE WEEKDAY( datum )
WHEN 0 THEN "radni dan"
WHEN 1 THEN "radni dan"
WHEN 2 THEN "radni dan"
WHEN 3 THEN "radni dan"
WHEN 4 THEN "radni dan"
WHEN 5 THEN 'subota'
WHEN 6 THEN 'nedjelja'
END dan, COUNT(*) as ContTip
FROM zaposlenik
GROUP BY dan