write the following queris in sql :

a) Using nested query , retreive the sependent names of male employees whose salary > 30000

b ) list the female employee, who are not managers

EMPLOYEE Fname MinitLname John Franklin T Wong 333445555 1955-12-08 638 Voss, Houston, TX M 4 Ssn Sex Salary Super sen Dno B Smith 123456789 1965 01-09 731 Fondren, Houston, TX M 30000 13334455 AliciaZelaya 999987777 1968-01-19 3321 Castle, Spring, TXF Jennifer S Wallace 987654321 1941-06-20 291 Berry, Bellaire, TX Ramesh K Narayan 666884444 1962-09-15 975 Fire Oak, Humble, TX M 380 Joyce A Engish 453453453 1972-07-31 5631 Rice, Houston, TXF 25000 Ahmad Jabbar 9879879871969-03-29 980 Dallas, Houston, TX M 25000 Jamcs EBorg 888665555 1937-11-10 450 Stone, Houston, TX M55000 4300 65555 4 38000 333445555 987654321 4 DEPARTMENT DEPT LOCATIONS Mgr.ssn 333445555 987654321 888665555 Mgr start date 1988-05-22 1995-01-01 5 5 WORKS ON PROJECT Pno Hours 132.5 7.5 3 40.0 Pnumber PlocalionDnum Bellaire 2 Sugarland 5 Pname 123456789 123456789 ProductY 68684444 3 0.0 462453453 453453453 333445555 333445555 3 333445555 333445555 2010.0 999887777 30 30.0 20.0- Computurication40 Stafford Reorganization 20 Houston Newbenefits 2 20.0 2 10.0 30 Stafford 310.0 10 10.0DEPENDENT Esan Dependent aa SesBdatoRohiterati' 333445555 Alice 333445555 Theodone 333445555 Joy F 1986-04-05 Daughter M 1983-10-25 Son F1958-05-03 Spouse M 194202-28 Spouse 99987772 10 10.0 10 35.0 987987987 98798798730 987654321 987654321 888665555 987854321 Abner .| M | 1988-01-04 | Son 30 20.0 20 15.0 20 NULL 123456789 Michael 123456789 Alice 123456789 Elizabeth F 1988-12-30Daughter F 1967-05-05 Spouse Scanned by CamScanner