ZOHO Newbie Help

Can someone help me on this?

How can a display only the names of Employees under a certain Manager?

SELECT EmployeeNames FROM EmployeeList WHERE EmployeeList.Manager=ManagerField.Name