You left out the where.
SELECT employee.name where role = 'developer'
Vs
SELECT staff.name” where role = 'developer'
Then the plural one reads better
SELECT employee.name where role = 'developer'
Vs
SELECT staff.name” where role = 'developer'
Then the plural one reads better
SELECT employee.Name
FROM employee
WHERE employee.Role = 'developer'
reads much better to me than SELECT employees.Name
FROM employees
WHERE employees.Role = 'developer'