1. List the employee SSN, first and last name, birth date, and salary of each employee.

2. For each project, list the project name and its average hours worked, but consider only those projects for which the average work hours is more than 15.

3. List the employee SSN and number of hours an employee has worked on a project.

4. Employees get a 10% increase in their salary. List employee SSN, first and last name, the old salary, and the new salary of each employee.

5. List the name of each employee who does not live in Illinois. Use conditional restriction IL in WHERE statement, not CA and MO.

6. List the name of employees whose address contains the word "Oak You have to use ADDRESS column in WHERE statement.

7. List all employees who earn more than $40,000, and are either in department 3 or are male. List each employee first and last name, salary, gender, and department number.

8. List all employees who earn exactly $43,000, $50,000, or $55,000. List each employee first and last name, and salary. Use IN operator. Do not use OR operator.

9. For each project, list project number and total hours worked per project. Label the two columns Project Number and Total Hours, respectively. Sort the output by Total Hours from largest to smallest.

10.List the employee first and last name who doesnt work on any project.

11.For each employee, list employee first and last name, the department the employee belongs to, hours worked on projects, project name.

t No Name Headquarters Admin and Records 999555555 Production Start Date 999666666 2005-06-19 2013-01-0 1998-05-22 999444444 Employee EMP SSN FName Name Address City DOB | Salary | Park- | Gender | Dep | Super-SSN t No Space 99 BockDouglas Verd 1955 30000 542 St. Louis MO 6312 7 999444444 3 999555555 7 1999444444 7999666666 999222222Amin Hyder Seaside Marina CA 93941 03-29 25000 422 M 999333333 Joshi Dinesh Oak St Consville IL 66234 38000 332 M 1975 43000 32 999444444 Zhu Waiman Lindber St. Louis MO 63121 555555 JoynerSuzanneBurns Marina CA93941 3 999666666 South |Edwardsvill | IL |62025|i1-10 967 55000 999666666 Bordoloi Bijoy Main High St. Monterey 1978 9394007-19 999887777 Markis Marcia CA9 25000 402 F 999555555 Overton Edwardsvill | Way #4 | e 999888888 Prescott Sherni 62025 07-31 25000 296 F 7 999444444 Number Work Hours