- SELECT COUNT(Datum) as UkupnoDana,
- (SELECT COUNT(DATE_FORMAT(datum,'%a'))as d FROM `zaposlenik` WHERE DATE_FORMAT(datum,'%a') ="Sat")as Subota,
- (SELECT COUNT(DATE_FORMAT(datum,'%a'))as d FROM `zaposlenik` WHERE DATE_FORMAT(datum,'%a') ="Sun")as Nedelja,
- (SELECT COUNT(DATE_FORMAT(datum,'%a'))as d FROM `zaposlenik` WHERE DATE_FORMAT(datum,'%a') IN ('Mon','Tue','Wed','Thu','Fri'))as RadniDan
- FROM `zaposlenik`