blob: fb678ba9edfa4bbfc2a09b746ea5a186afa60220 [file] [log] [blame]
SELECT
m.employee_id,
(
SELECT
sub.full_name
FROM
cp.`employee.json` as sub
WHERE
sub.full_name >= 'Maya Gutierrez'
LIMIT 1
) as full_name
FROM
cp.`employee.json` as m
WHERE
m.gender LIKE 'F' LIMIT 5;