รบกวนช่วยหน่อยค่ะ เรื่อง หาผลรวมข้อมูล (sum) ค่ะ

SELECT  EMPLOYEE.MEMP , EMPLOYEE.MPNAME + CHAR(9) +  EMPLOYEE.MFNAME + CHAR(9) AS NAME , EMPLOYEE.MFLASTNAME, Min(Interest.MINTEREST)
FROM Interest INNER JOIN EMPLOYEE ON EMPLOYEE.MEMP = Interest.MEMP 
INNER JOIN EMPLOYEEDT ON EMPLOYEE.MEMP = EMPLOYEEDT.MEMP 
WHERE  Interest.YEAR = '2557' 
Group by EMPLOYEE.MEMP , EMPLOYEE.MPNAME + CHAR(9) +  EMPLOYEE.MFNAME + CHAR(9) AS NAME , EMPLOYEE.MFLASTNAME
ORDER BY EMPLOYEE.MEMP ;

SELECT  EMPLOYEE.MEMP , EMPLOYEE.MPNAME + CHAR(9) +  EMPLOYEE.MFNAME + CHAR(9) AS NAME , EMPLOYEE.MFLASTNAME, (Select Min(Interest.MINTEREST) From Interest Where EMPLOYEE.MEMP = Interest.MEMP) MINTEREST
FROM EMPLOYEE INNER JOIN EMPLOYEEDT ON EMPLOYEE.MEMP = EMPLOYEEDT.MEMP 
WHERE  Interest.YEAR = '2557' 
ORDER BY EMPLOYEE.MEMP ;

SELECT  EMPLOYEE.MEMP , 
EMPLOYEE.MPNAME + CHAR(9) +  EMPLOYEE.MFNAME + CHAR(9) AS NAME , EMPLOYEE.MFLASTNAME, 
EmployeeDT.SAVINGDEP , Interest.MINTEREST ,EmployeeDT .FUND 
FROM Interest INNER JOIN EMPLOYEE ON EMPLOYEE.MEMP = Interest.MEMP 
INNER JOIN EMPLOYEEDT ON EMPLOYEE.MEMP = EMPLOYEEDT.MEMP 
WHERE  Interest.YEAR = '2557' 
ORDER BY EMPLOYEE.MEMP ;

SELECT MEMP ,SUM(MINTEREST) MINTEREST
FROM Interest
WHERE (MEMP = 9)
GROUP BY MEMP

SELECT  EMPLOYEE.MEMP , 
EMPLOYEE.MPNAME + CHAR(9) +  EMPLOYEE.MFNAME + CHAR(9) AS NAME , 
EMPLOYEE.MFLASTNAME, 
EmployeeDT.SAVINGDEP , Interest.MINTEREST ,EmployeeDT .FUND 
,
SUM(Interest.MINTEREST) AS SUM_MINTEREST

FROM Interest 
INNER JOIN EMPLOYEE ON EMPLOYEE.MEMP = Interest.MEMP 

INNER JOIN EMPLOYEEDT ON EMPLOYEE.MEMP = EMPLOYEEDT.MEMP 


WHERE  Interest.YEAR = '2557' 
GROUP BY EMPLOYEE.MEMP, 
EMPLOYEE.MPNAME + CHAR(9) +  EMPLOYEE.MFNAME + CHAR(9), EMPLOYEE.MFLASTNAME, 
EmployeeDT.SAVINGDEP , Interest.MINTEREST ,EmployeeDT .FUND
ORDER BY EMPLOYEE.MEMP ;

SELECT  EMPLOYEE.MEMP , EMPLOYEE.MPNAME + CHAR(9) +  EMPLOYEE.MFNAME + CHAR(9) AS NAME , EMPLOYEE.MFLASTNAME, EmployeeDT .SAVINGDEP , EmployeeDT .FUND ,SUM(Interest.MINTEREST)
FROM Interest INNER JOIN EMPLOYEE ON EMPLOYEE.MEMP = Interest.MEMP 
INNER JOIN EMPLOYEEDT ON EMPLOYEE.MEMP = EMPLOYEEDT.MEMP 
WHERE  Interest.YEAR = '2557' 
Group by EMPLOYEE.MEMP , EMPLOYEE.MPNAME ,  EMPLOYEE.MFNAME  , EMPLOYEE.MFLASTNAME ,EmployeeDT .SAVINGDEP , EmployeeDT .FUND
ORDER BY EMPLOYEE.MEMP ;