[ninechances]

I need some help putting this together. I have a database that looks like the following:

Employee (empNo, fName, lName, address, DOB, sex, position, deptNo)
Department (deptNo, deptName, mgrEmpNo)


I need to figure out how to display the total amount of employees that are managed by James Adams.

This is what I have but I think it's only going to produce '1' because I think it is saying "Count total employees who have the position manager, first names James and last name Adams.

ℑCOUNT _empNo (σ _{position = 'manager' ∧ fName = "James" ∧ lName="Adams"}(Employee))

Any Help is appreciated.