Text: Specify the following queries in SQL based on the COMPANY relational database schema shown below (actual SQL implementation is not required). The correct SQL code should assume the data shown in table COMPANY is only a sample size. Your code should adapt to any data. Hence, do not hardcode values.
A. Retrieve the names of all employees in department 5 who work more than 10 hours per week.
B. List the names of all employees who have a dependent with the same first name as themselves.
C. Given only "Franklin Wong", find the names of all employees who are directly supervised by "Franklin Wong".
EMPLOYEE
Fname
Minit
Lname
Ssn
Bdate
Address
Sex
Salary
Super_ssn
Dno
Smith
123456789
1965-01-09
731 Fondren Houston, TX
30000
333445555
Wong
333445555
1955-12-08
638 Voss, Houston, TX
40000
888665555
Zelaya
999887777
1968-01-19
3321 Castle Spring IX
25000
987654321
Wallace
987654321
1941-06-20
291 Berny Bellaire, TX
43000
888665555
Narayan
666884444
1962-09-15
975 Fuo ' Oak Humblo, TX
38000
333445555
English
453453453
1972-07-31
5631 Rice Houston, TX
25000
333445555
Jabbar
987987987
1969-03-29
980 Dallas, Houston, TX
25000
987854321
John
Franklin
Alicia
Jenniler
Ramosh
Joyco
Ahmad
Jamus
Borg
888665555
1937-11-10
450 Stone, Houston
55000
NULL
DEPARTMENT
DEPT_LOCATIONS
Dnumber
Dlocation
Dname
Dnumber
Mgr_ssn
333445555
987654321
Mgr_start_date
1988-05-22
1995-01-01
1981-06-19
Research
Administration
Headquarters
Houston
Stafford
Bellaire
Sugarland
Houston
888665555
WORKS_ON
PROJECT
Essn
Pno
Hours
Pname
Pnumber
Plocation
Dnum
123456789
123456789
666884444
453453453
453453453
32.5
Product X
Product Y
Product Z
Bellaire
Sugarland
Houston
40.0
20.0
Computerization
Reorganization
New benefits
Stafford
Houston
Stafford
20.0
10.0
10.0
10.0
10.0
30.0
10.0
35.0
333445555
333445555
333445555
DEPENDENT
Essn
333445555
999887777
999887777
987987987
987987987
Dependent name
Sex
Bdate
Relationship
986-04-05
Daughter
1983-10-25
Son
1958-05-03
Spouse
1942-02-28
Spouse
333445555
333445555
333445555
Alice
Theodore
Joy
Abner
5.0
987654321
987654321
987654321
20.0
123456789
Michael
Alice
1988-01-04
1988-12-30
1967-05-05
Son
Daughter
Spouse
15.0
123456789
123456789
888665555
NULL
Elizabeth