Oracle 18c

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE AIRPLANE (AIRPLANEID, AIRPLANENAME, CRUISINGRANGE) AS
  SELECT 1, 'PIPER CUB', 100 FROM DUAL UNION ALL
  SELECT 2, 'CESSNA 150', 250 FROM DUAL UNION ALL
  SELECT 3, 'BOEING 737', 2500 FROM DUAL UNION ALL
  SELECT 4, 'LOCKHEED ELECTRA', 5000 FROM DUAL UNION ALL
  SELECT 5, 'BOEING 747', 9000 FROM DUAL UNION ALL
  SELECT 6, 'SPACE SHUTTLE', 99999999 FROM DUAL
6 rows affected

CREATE TABLE EMPLOYEES (EMPLOYEEID, EMPLOYEENAME, SALARY) AS
  SELECT 1, 'HOMER', 100 FROM DUAL UNION ALL
  SELECT 2, 'CRASH', 200 FROM DUAL UNION ALL
  SELECT 3, 'ACE', 300 FROM DUAL
3 rows affected

CREATE TABLE CERTIFIED (EMPLOYEEID, AIRPLANEID) AS
  SELECT 1, 1 FROM DUAL UNION ALL
  SELECT 1, 2 FROM DUAL UNION ALL
  SELECT 1, 3 FROM DUAL UNION ALL
  SELECT 1, 4 FROM DUAL UNION ALL
  SELECT 2, 1 FROM DUAL UNION ALL
  SELECT 2, 2 FROM DUAL UNION ALL
  SELECT 2, 3 FROM DUAL UNION ALL
  SELECT 2, 5 FROM DUAL UNION ALL
  SELECT 3, 1 FROM DUAL UNION ALL
  SELECT 3, 2 FROM DUAL UNION ALL
  SELECT 3, 3 FROM DUAL UNION ALL
  SELECT 3, 4 FROM DUAL UNION ALL
  SELECT 3, 6 FROM DUAL
13 rows affected

SELECT Employees.employeeName, MAX(Airplane.cruisingRange)
FROM Employees
JOIN Certified ON Employees.employeeID = Certified.employeeID
JOIN Airplane ON Airplane.airplaneID = Certified.airplaneID
GROUP BY Employees.employeeName
HAVING COUNT(*) > 3
ORDER BY EMPLOYEES.EMPLOYEEID
ORA-00979: not a GROUP BY expression