Databases Help Using the tables given find the resulting ta

Databases Help - Using the tables given, find the resulting tables:

1. Find flno of flights that can be piloted by every pilot whose salary is over $100,000.

2. Solve problem 1 without using the division operator.

3. Find names of pilots who can operate planes with a range greater than 3,000 miles, but are not certified on any Boeing.

4. Find eid of employee(s) with the highest salary.

5. Find eid of employee(s) with the second highest salary.

Tables:

Flights flno from distance departs to NY Denver 100 LA 101 Dullas 102 DenverDullas 103 NY 104 Rich 105 LA 106 Nash 107 Rich 108 LA 109 Dullas LA Dullas Nash Rich Dullas NY Rich 2295 Mon 1635 Tues 1700 Wed 2050 Thru 1900 Fri 1350 Sat 925 Surn 1630 Mon 2400 Tues 1165 Wed

Solution

1)
select aid from Aircraft where aid in(select aid from Certified where eid in(select eid from Employees where salary>100000));

3)select ename from Employees where eid in(select eid from from Certified where aid in(select aid from Aircraft where range>3000) and aid not in(select aid from Aircraft where a name=\'Boeing\')));

4) select eid from Employees where salary in(select max(salary) from Employees)

5) select eid from Employees where salary in(select max(salary) from Employees where salary not in(select max(salary) from Employees));