question

Kindly help me with this...as am a newbies to SQL ******************* TABLES WITH DATA ******************* create table division (did integer, dname varchar (25), managerID integer, constraint division_did_pk primary key (did) ); create table employee (empID integer, name varchar(30), salary float, did integer, constraint employee_empid_pk primary key (empid), constraint employee_did_fk foreign key (did) references division(did) ); create table project (pid integer, pname varchar(25), budget float, did integer, constraint project_pid_pk primary key (pid), constraint project_did_fk foreign key (did) references division(did) ); create table workon (pid integer references project(pid), empID integer references employee(empID), hours integer, constraint workon_pk primary key (pid, empID), constraint workon_pid_fk foreign key(pid) references project(pid), constraint workon_empid_fk foreign key(empid) references employee(empid) ); /* loading the data into the database */ insert into division values (1,'engineering', 2); insert into division values (2,'marketing', 1); insert into division values (3,'human resource', 3); insert into division values (4,'Research and development', 5); insert into division values (5,'accounting', 4); insert into project values (1, 'DB development', 8000, 2); insert into project values (2, 'network development', 6000, 2); insert into project values (3, 'Web development', 5000, 3); insert into project values (4, 'Wireless development', 5000, 1); insert into project values (5, 'security system', 6000, 4); insert into project values (6, 'system development', 7000, 1); insert into employee values (1,'kevin', 32000,2); insert into employee values (2,'joan', 42000,1); insert into employee values (3,'brian', 37000,3); insert into employee values (4,'larry', 82000,5); insert into employee values (5,'harry', 92000,4); insert into employee values (6,'peter', 45000,2); insert into employee values (7,'peter', 68000,3); insert into employee values (8,'smith', 39000,4); insert into employee values (9,'chen', 71000,1); insert into employee values (10,'kim', 46000,5); insert into employee values (11,'smith', 46000,1); insert into workon values (3,1,30); insert into workon values (2,3,40); insert into workon values (5,4,30); insert into workon values (6,6,60); insert into workon values (4,3,70); insert into workon values (2,4,45); insert into workon values (5,3,90); insert into workon values (3,3,100); insert into workon values (6,8,30); insert into workon values (4,4,30); insert into workon values (5,8,30); insert into workon values (6,7,30); insert into workon values (6,9,40); insert into workon values (5,9,50); insert into workon values (4,6,45); insert into workon values (2,7,30); insert into workon values (2,8,30); insert into workon values (2,9,30); insert into workon values (1,9,30); insert into workon values (1,8,30); insert into workon values (1,7,30); insert into workon values (1,5,30); insert into workon values (1,6,30); insert into workon values (2,6,30); ********************** QUERIES TO WORKON ********************** 1 List the name of employee and the number of project he/she works on (use join) 2 For each division, list the name of project whose budget is highest in that division, also list the division name (corelated subquery). 3. List the total number of projects whose budget is above the average project budget. 4. List the name of the division that has more than 2 employees who participate in project. 5. List the name of employee who work on more than 2 projects 6. Increase the budget of the project by if 10% if it has two or more employees working on it 7. List the name of the manager (note, if an employee's ID is in the Division table then s/he is a manager) and her/his total working hours on projects (the hours employee working on the project). 8. List the name of the managers who do not work on any projects. (note, the manager is the employee whose ID is in division table) 9. List the name(s) of employees who is/are working on some project(s) but not on the project "Web development" 10 List the name of the division that has at least one employee who works on a project that is not sponsored by his division (MUST use EXISTS) 11. List the name of employee who works on a project that is from his own division (i.e., the project's DID = employee's DID, use corelated subquery) . 12 (bonus question) List the name of the employee whose salary is below the company average but the total number of projects he/her work on is above the employee’s average (i.e., the average of number of projects an employee work on) .