create table Employee ( eid int, name varchar(20), age int, salary float, residenceState char(2), startDate date, Primary Key (eid) ) ;

create table Department ( did int, name varchar(20), floor int, supplyBudget float, stateLocated char(2), PRIMARY KEY (did) ) ;

create table WorksFor ( eid int, did int, startDate date, PRIMARY KEY (did,eid), Foreign Key (did) references Department(did), Foreign Key (eid) references Employee(eid) ) ;

create table managers( eid int, did int, managersStartDate date, Primary Key (eid,did), Foreign Key (eid) references employee (eid), Foreign Key (did) references department (did));

Q1. Find the (eid,number) pair for employees who are managing two or more departments where "number" is the number of departments they are managing.

Q2.For each department in Alaska ('AK') that has 25 or more employees working for it and a supply budget < $7,000, present the did, budget, and number of employees that work in that department.

Q3. : For each state, present the salary of the average 20-yearold manager (i.e., average salary of mangers who are 20 years old) who lives in that state and the number of such managers. Note: Your results can omit states that do not have any 20-yearold managers living in them.