Based on the example COMPANY Database studied in our course, answer the following questions using SQL.
Retrieve the birthdate and address of the employee who is the manager of the department administration.
Retrieve the first name and the last name of all employees whose salary is between 25000 and 45000.
Retrieve all employees working on project number 2 with a number of hours lower than or equal to 10.
Retrieve the department number and department name for each department having at least three employees.
EMPLOYEE FNAME MINIT LNAME SSN BDATE ADDRESS SEX SALARY SUPERSSN DNO
John B Smith 123456789 1965-01-09 731 Fondren, Houston, TX M 30000 333445555 5
Franklin T Wong 333445555 1955-12-08 638 Voss, Houston, TX M 40000 888665555 4
Alicia J Zolaya 999887777 1968-07-19 3321 Castle, Spring, TX M 25000 6
Jennifer S Wallace 987654321 1941-06-20 291 Berry, Bellaire, TX F 43000 987654321 5
Ramesh K Narayan 666884444 1962-09-15 975 Fire Oak, Humble, TX M 38000 888665555 5
Joyce A English 453453453 1972-07-31 5631 Rice, Houston, TX M 25000 333445555 5
Ahmad A Jabbar 987987987 1969-03-29 980 Dallas, Houston, TX M 25000 333445555 5
searer Borg 888665555 1937-11-10 450 Stone, Houston, TX M 55000 null null
DEPT_LOCATIONS DNUMBER DLOCATION
4 Houston
5 Stafford
5 Bellaire
5 Sugartand
5 Houston
DEPARTMENT DNAME DNUMBER MGRSSN MGRSTARTDATE
Research 5 333445555 1988-05-22
Administration 4 987654321 1995-01-01
Headquarters 1 888665555 1981-06-19
WORKS_ON ESSN PNQ HOURS
123456789 2 32.5
123456789 3 7.5
666884444 1 40.0
453453453 2 20.0
453453453 2 20.0
333445555 3 10.0
333445555 10 10.0
333445555 20 10.0
333445555 30 10.0
999887777 10 30.0
999887777 10 10.0
987987987 30 35.0
987987987 30 5.0
987654321 20 20.0
987654321 20 15.0
888665555 null null
PROJECT PNAME PNUMBER PLOCATION DNUM
ProductX 2 Bellaire 5
ProductY 3 Sugartand 5
ProductZ 10 Houston 5
Computerization 20 Stafford 5
Reorganization 30 Houston 5
Newbenefits 4 null null
DEPENDENT ESSN DEPENDENT_NAME SEX BDATE RELATIONSHIP
333445555 Alice F 1986-04-05 DAUGHTER
333445555 Theodore M 1983-10-25 SON
333445555 Joy F 1958-05-03 SPOUSE
987654321 Abner M 1942-02-28 SPOUSE
123456789 Michael M 1988-01-04 SON
123456789 Alice F 1988-12-30 DAUGHTER
123456789 Elizabeth F 1967-05-05 SPOUSE