SELECT If(DATE_FORMAT(Datum,'%w') Between 2 And 6,'RadniDan',DATE_FORMAT(Datum,'%a')) AS Dan, Count(DATE_FORMAT(Datum,'%a')) AS Ukupno
FROM zaposlenik
GROUP BY If(DATE_FORMAT(Datum,'%w') Between 2 And 6,'RadniDan',DATE_FORMAT(Datum,'%a'))