SELECT id, name, surname
FROM team_members
WHERE NOT
EXISTS (

SELECT *
FROM team_members_functions
WHERE team_members.id = team_members_functions.team_member
)