Can you display the salary and name of the employees?
select salary, name from employee
What is the name of the employee who has the most number of aircraft certificates?
select t1.name from employee as t1 join certificate as t2 on t1.eid = t2.eid group by t1.eid order by count ( * ) desc limit 1
Hmm, can you just list his salary?
select 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