SELECT DATEDIFF(eleave.resume_date , eleave.leave_date) as total_days , (
 ABS(DATEDIFF(eleave.leave_date, eleave.resume_date)) -
 ABS(DATEDIFF(ADDDATE(eleave.leave_date, INTERVAL 1 -
 DAYOFWEEK(eleave.leave_date) DAY) , ADDDATE(eleave.resume_date, INTERVAL
1  - DAYOFWEEK(eleave.resume_date) DAY))) / 7 * 2 -
 (DAYOFWEEK(IF(eleave.resume_date < eleave.leave_date , leave.resume_date,
eleave.leave_date)) = 1) - (DAYOFWEEK(IF(eleave.resume_date >
eleave.leave_date, eleave.resume_date, eleave.leave_date)) = 7)) as
leavedays , employee.emp_lname , type.typ_name as leavetype ,
education.qualification , education.program FROM employee INNER JOIN eleave on employee.emp_num = eleave.emp_num LEFT JOIN type ON type.typ_id =
eleave.typ_id left join education ON employee.emp_num = education.emp_num
 WHERE employee.emp_num = 4774 AND type.typ_name = 'Sick leave'

SELECT employee.emp_num, SUM (ABS(DATEDIFF(eleave.leave_date, eleave.resume_date)) -  ABS(DATEDIFF(ADDDATE(eleave.leave_date, INTERVAL 1 - DAYOFWEEK(eleave.leave_date) DAY) , ADDDATE(eleave.resume_date, INTERVAL
1  - DAYOFWEEK(eleave.resume_date) DAY))) / 7 * 2 -
 (DAYOFWEEK(IF(eleave.resume_date < eleave.leave_date , leave.resume_date,
eleave.leave_date)) = 1) - (DAYOFWEEK(IF(eleave.resume_date >
eleave.leave_date, eleave.resume_date, eleave.leave_date)) = 7)) as
leavedays

ROM employee INNER JOIN eleave on employee.emp_num = eleave.emp_num LEFT JOIN type ON type.typ_id =
eleave.typ_id left join education ON employee.emp_num = education.emp_num
 WHERE employee.emp_num = 4774 AND type.typ_name = 'Sick leave'

GROUP BY employee.emp_num