framework/resources/Functional/subqueries/subquery_in_select/where_not_in.sql

SELECT
  m.employee_id,
  (
    SELECT
      sub.full_name
    FROM
      cp.`employee.json` as sub
    WHERE
      sub.full_name NOT IN ('Roberta Damstra', 'Derrick Whelply')
    LIMIT 1
  ) as full_name
FROM
  cp.`employee.json` as m
WHERE
  m.gender LIKE 'F' LIMIT 5;