Zoom
1
2
NumOf Employee
Dnumber Dname
Administration 3
--
Research
Picture 5.1
3
Question 6:
Write a query to get all employees that have no dependent or all dependents's age are below 18. The result as follow:
Fname Minit Lname San
Bdate
Address
Sex Salary
Ahmad V
Jabbar 987987987 1969-03-29 980 Dallas, Houston, TX M
Ahn C
Seop
654321789 1988-11-07 456 Green, Houston, TX M 3321 Castle, Spring, TX F
Alicia J
Zelaya 999887777 1968-01-19
Cross E Anie
141146213 2003-11-15
Ho M Piter
Huynh T Toan
James E
Borg
Joyce A
Ram... K
25000.00
Super ssn Dno
987654321 4
80000.00 333445555 5
25000.00 987654321 4
678 NTT, HCM, TX
F
40000.00 987654321 4
345345345 1975-11-11 123 Blue, Houston, TX
123123123 1975-11-11 700 Blue, Houston, TX M
M
35000.00 123123123 3
40000.00 888665555 3
888665555 1937-11-10 450 Stone, Houston, TX M
55000.00 NULL
1
Engli... 453453453
1972-07-31 Nara... 666884444 1962-09-15 915
5631 Rice, Houston, TX Fire Oak, Humble....FM
30000.00 333445555 5
38000.00 333445555 5
Picture 6.1
5 of 5
Paper No: 1
Question 7:
85%
TeamViewer
Close
ENG
INTL
5:40 pm
18/03/2023
