Questions about in SQL statements

In SQL statements my usersys table is like this submit_user table is my SQL statement: SELECTfullname, sum (jkd) & nbsp; FROMsubmit_userWHEREfullnameIN (contains the problem of in SQL statements)
My usersys table is like this.

The submit_user table is

My SQL statement is:
SELECT fullname, sum (jkd)
FROM submit_user
WHERE fullname
IN (

SELECT fullname
FROM usersys
WHERE Department = 'photo and Video production'
)
AND submit_date
BETWEEN '2017-08-09'
AND '2017-08-26'

But the result is incorrect. The result is

What I should have gotten is the sum of all the jkd personnel in the department, but it's strange that only one person is available. please help me to see where is the problem?

------ Solution --------------------
SELECT fullname, sum (jkd)
FROM submit_user
WHERE fullname
IN (

SELECT fullname
FROM usersys
WHERE Department = 'photo and Video production'
)
AND submit_date
BETWEEN '2017-08-09'
AND '2017-08-26'
Group by fullname