MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE Employees (`employeeid` INTEGER, `name` VARCHAR(12));

INSERT INTO Employees (`employeeid`, `name`) VALUES
  ('110', 'Jim Sullivan'),
  ('111', 'Anna Schmidt'),
  ('112', 'James Lee');

CREATE TABLE Workson (`projectid` INTEGER, `employeeid` INTEGER);

INSERT INTO Workson (`projectid`, `employeeid`) VALUES
  ('6554', '110'),
  ('6554', '111'),
  ('6555', '110'),
  ('6555', '111'),
  ('6556', '110'),
  ('6556', '111'),
  ('6556', '112');
CREATE TABLE Projects(
projectid  integer,	projectName varchar(20));

insert into Projects VALUES
(6556,	'POPS'),
(6555,	'BABY'),
(6554,	'MAMA'),
(6558,	'NO-WORKERS');
SELECT 
   p.projectid, 
   p.projectName
FROM Projects p
INNER JOIN Workson w1 ON w1.projectid = p.projectid
INNER JOIN Workson w2 ON w2.projectid = p.projectid
INNER JOIN Employees e1 ON e1.employeeid = w1.employeeid
INNER JOIN Employees e2 ON e2.employeeid = w2.employeeid
WHERE e1.name LIKE 'jim%sullivan%'
  AND e2.name LIKE 'anna%schmidt%';


projectid
projectName


6554
MAMA

6555
BABY

6556
POPS