SELECT IF( DATE_FORMAT( Datum,  '%w' ) 
BETWEEN 1 
AND 5 ,  'RadniDan', DATE_FORMAT( Datum,  '%a' ) ) AS Dan, COUNT( DATE_FORMAT( Datum,  '%a' ) ) AS Ukupno
FROM zaposlenik
WHERE MONTH( datum ) =7 //za 7mjesec
AND odSati >0 //pocetak rada nesmije biti 0 
GROUP BY IF( DATE_FORMAT( Datum,  '%w' ) 
BETWEEN 1 
AND 5 ,  'RadniDan', DATE_FORMAT( Datum,  '%a' ) ) 
LIMIT 0 , 31