text: CREATE TABLE Aircraft (aid VARCHAR, distance INTEGER); CREATE TABLE Employee (name VARCHAR, eid VARCHAR); CREATE TABLE Certificate (eid VARCHAR, aid VARCHAR) -- What is the salary and name of the employee who has the most number of certificates on aircrafts with distance more than 5000? SELECT T1.name FROM Employee AS T1 JOIN Certificate AS T2 ON T1.eid = T2.eid JOIN Aircraft AS T3 ON T3.aid = T2.aid WHERE T3.distance > 5000 GROUP BY T1.eid ORDER BY COUNT(*) DESC LIMIT 1 CREATE TABLE Allergy_type (allergy VARCHAR) -- How many allergies are there? SELECT COUNT(DISTINCT allergy) FROM Allergy_type CREATE TABLE Allergy_type (allergytype VARCHAR) -- How many different allergy types exist? SELECT COUNT(DISTINCT allergytype) FROM Allergy_type CREATE TABLE Allergy_type (allergytype VARCHAR) -- Show all allergy types. SELECT DISTINCT allergytype FROM Allergy_type CREATE TABLE Allergy_type (allergy VARCHAR, allergytype VARCHAR) -- Show all allergies and their types. SELECT allergy, allergytype FROM Allergy_type CREATE TABLE Allergy_type (allergy VARCHAR, allergytype VARCHAR) -- Show all allergies with type food. SELECT DISTINCT allergy FROM Allergy_type WHERE allergytype = "food" CREATE TABLE Allergy_type (allergytype VARCHAR, allergy VARCHAR) -- What is the type of allergy Cat? SELECT allergytype FROM Allergy_type WHERE allergy = "Cat" CREATE TABLE Allergy_type (allergytype VARCHAR) -- How many allergies have type animal? SELECT COUNT(*) FROM Allergy_type WHERE allergytype = "animal"