CREATE TABLE employee (eid NUMBER, name CLOB, salary NUMBER)
CREATE TABLE certificate (eid NUMBER, aid NUMBER)
CREATE TABLE flight (flno NUMBER, origin CLOB, destination CLOB, distance NUMBER, departure_date TIME, arrival_date TIME, price NUMBER, aid NUMBER)
CREATE TABLE aircraft (aid NUMBER, name CLOB, distance NUMBER)

what is the salary and name of the employee who has the most number of aircraft certificates?
SELECT T1.name, T1.salary FROM employee AS T1 JOIN certificate AS T2 ON T1.eid = T2.eid GROUP BY T1.eid ORDER BY COUNT(*) DESC LIMIT 1
SELECT "T1"."name", "T1"."salary" FROM "employee" "T1" JOIN "certificate" "T2" ON "T1"."eid" = "T2"."eid" GROUP BY "T1"."eid" ORDER BY COUNT(*) DESC FETCH FIRST 1 ROWS ONLY