Crew information in a fastfood restaurant EN o
Lname
Fname
M I
Statio n
E 109 E 228 E 115 E 227 E 201 E 202 E 226 E 203 E 167 E 224 E 225 E 204 E 206 E 207 E 208 E 209 E 210 E 211 E 212 E 213 E 214 E 215 E 216 E 217 E 218 E 219 E 220 E 221 E 222 E 223
Santos
Evelyn
Castro
Jelaine
Magat
Ryza
Dizon
Ariel
Reyes Saizon
Jan Michael Carlo
Reyes
Cory
Ito
Seiko
Arroyo
Aster
Aman
Charisse
Camus
Cristine
Estrella
Allan
Santos
Harry
B . D . U . M . M . E . G . M . A . S . C . A . P.
Dizon
Elaine
L.
Reyes
Jaime
Bedeo
Carla
Doming uez Sayco
Joaquin
D . M . T.
Santos
Edison
Castro
Jeffrey
Salazar
Michael
Santos
Yla
Hebron
Robin
Cabilin
Mary
Tolentin o Sorio
Ariel
Sylvia
Michael
Menese s Ignacio
Donna
Co
Jackiely n Kimpee
Blaza
Daisy
Stat us
Bday
Add
SC
G ende r F
M
Pantry
F
S
PC
F
M
Dining
M
S
Backup Fry
M
S
M
S
Grill
F
S
Grill
F
S
Tungkong Mangga, CSJDM Palmera Homes, CSJDM Palmera Homes, CSJDM Francisco Homes, CSJDM Palmera Homes, CSJDM Francisco Homes, CSJDM Francisco Homes, CSJDM Malaria, Caloocan
PC
M
M
Dining
F
S
Counte r Grill
F
S
M
S
Stock man Counte r Grill
M
S
F
S
M
S
Pantry
F
S
Dining
M
S
B . T.
Pantry
F
S
Fry
M
S
C . J.
Dining
M
S
Backup Counte r Soda
M
S
F
S
M
S
Pantry
F
S
Stock man Backup SC
M
S
M
S
F
S
Counte r Counte r Soda
F
S
F
S
M
S
17-Feb80 26May-88 27May-84 27-Nov90 15-Jan89 11-Nov89 01-Oct90 29-Jan87 29-Nov80 12-Jun91 23-Sep88 15-Jul90 15-Aug90 02Dec-89 04-Mar88 13-Jun87 13-Jan90 25-Oct89 15-Feb88 01-Feb90 19-Aug90 26May-91 08-Aug89 31-Oct90 18-Apr89 25Dec-90 17-Mar89 25Dec-88 26-Apr87 16-Apr89
D . C . P. M . C . C . L. D . E .
Francisco Homes, CSJDM Palmera Homes,CSJDM Francisco Homes, CSJDM Francisco Homes, CSJDM Francisco Homes, CSJDM Francisco Homes, CSJDM Muzon, CSJDM Francisco Homes, CSJDM Palmera Homes, CSJDM Muzon, CSJDM Sta. Maria, Bulacan Palmera Homes, CSJDM Gumaoc, CSJDM Palmera Homes, CSJDM Francisco Homes, CSJDM Sapang Palay, Bulacan Sapang Palay, Bulacan Muzon, CSJDM Tungkong Mangga, CSJDM Sto. Cristo, CSJDM Tungkong Mangga, CSJDM Muzon, CSJDM
AND 1. Display all fields where gender is equal to female and status is equal to married. SELECT * FROM emp_info
Contact No 0917658 3489 0918375 6511 0920987 4564 0919876 1123 0928778 6711 0918761 1375 0922876 1222 0919123 4567 0922567 8112 0922455 3255 0918672 3552 0919892 3675 0909357 8877 0922897 6573 0915775 3821 0909876 3456 0919281 1379 0919781 1311 0928345 8765 0908461 3365 0916889 7656 0928593 3271 0928145 3567 0935787 1121 0919751 1232 0918671 1223 0917889 6543 0919723 6543 0929874 3128 0908765 8771
WHERE gender='F' AND status='M'; En o E 109 E 115
L nam e Sant os M agat
F nam e Evel yn Ryza
M I
Stati on
Stat us
Bday
Add
Contact No
SC
G ende r F
B . U .
M
PC
F
M
17-Feb80 27May-84
Tungkong Mangga, CSJDM Palmera Homes, CSJDM
0917658 3489 0920987 4564
2. Display employee number, last name, first name station and gender of crew whose station is grill and whose gender is male. SELECT EmpNo, Lname, Fname, Station, Gender FROM emp_info WHERE Station='Grill' AND Gender= 'M'; En o E 208 E 204
L nam e Reye s Estre lla
F nam e Jaim e Allan
Stati on
Gend er
Grill
M
Grill
M
3. Display all fields where last name is Santos and Gender is female. SELECT * FROM emp_info WHERE Lname='Santos' AND Gender='F'; En o E 109 E 215
L nam e Sant os Sant os
F nam e Evel yn Yla
M I
Stati on
B . D .
SC Coun ter
G ende r F
Stat us
Bday
Add
Contact No
M
F
S
17-Feb80 26May-91
Tungkong Mangga, CSJDM Palmera Homes, CSJDM
0917658 3489 0928593 3271
4. Display all fields where address starts with F and Status is single. SELECT * FROM emp_info WHERE Add like 'F*' AND Status='S'; En o E 216 E 209 E 202 E 207 E 204 E 206 E 225 E 226 E 227
L nam e Hebr on Bede o Saizo n Dizo n Estre lla Sant os C amu s Reye s Dizo n
F nam e Robi n Carla Carlo Elain e Allan
M I
Statio n
C . M . E . L.
Harry
A . P.
Cristi ne
C .
Cory
G . M .
Ariel
Stat us
Bday
Add
Contact No
Soda
G ende r M
S
Pantry
F
S
Fry
M
S
Counte r Grill
F
S
M
S
Stock man Counte r
M
S
F
S
08Aug-89 13-Jun87 11Nov-89 02Dec-89 15-Jul90 15Aug-90 23Sep-88
Francisco Homes, CSJDM Francisco Homes, CSJDM Francisco Homes, CSJDM Francisco Homes, CSJDM Francisco Homes, CSJDM Francisco Homes, CSJDM Francisco Homes, CSJDM
0928145 3567 0909876 3456 0918761 1375 0922897 6573 0919892 3675 0909357 8877 0918672 3552
Grill
F
S
Dining
M
S
01-Oct90 27Nov-90
Francisco Homes, CSJDM Francisco Homes, CSJDM
0922876 1222 0919876 1123
5. Display all fields where birth year is 1990.
SELECT * FROM emp_info WHERE Bday >= #1/1/90# AND Bday<=#12/31/90#; En o
Lname
F nam e Joaqu in Jeffre y Mich ael Mary
M I
Statio n
E 210 E 213 E 214 E 217 E 219 E 204 E 206 E 226 E 227
Doming uez Castro
T. C . J.
Estrella
Mich ael Allan
Santos
Harry
C . A . P.
Reyes
Cory
Dizon
Ariel
Salazar Cabilin Sorio
P.
G . M .
Stat us
Bday
Add
Dining
G ende r M
Contact No
S
Dining
M
S
Backup Pantry
M
S
Palmera Homes, CSJDM Palmera Homes, CSJDM Gumaoc, CSJDM
F
S
Backup Grill
M
S
M
S
Stock man Grill
M
S
F
S
Dining
M
S
13-Jan90 01-Feb90 19Aug-90 31-Oct90 25Dec-90 15-Jul90 15Aug-90 01-Oct90 27Nov-90
Sapang Palay, Bulacan Muzon, CSJDM Francisco Homes, CSJDM Francisco Homes, CSJDM Francisco Homes, CSJDM Francisco Homes, CSJDM
0919281 1379 0908461 3365 0916889 7656 0935787 1121 0918671 1223 0919892 3675 0909357 8877 0922876 1222 0919876 1123
6. Display all fields where address starts with F and contact number starts with 0919. SELECT * FROM emp_info WHERE Add like 'F*' AND ContactNo like '0919*'; En o
L nam e Estre lla Dizo n
E 204 E 227
F nam e Allan Ariel
M I
Stati on
A . M .
Grill Dinin g
G ende r M
Stat us
Bday
Add
S
M
S
15-Jul90 27Nov-90
Francisco Homes, CSJDM Francisco Homes, CSJDM
Contact No 0919892 3675 0919876 1123
7. Display all fields where gender is female, status is single and contact number starts with 0919. SELECT * FROM emp_info WHERE Gender='F' AND Status= 'S' AND ContactNo like '0919*'; En o E 203 E 221 E 211
L nam e Ito Igna cio Sayc o
F nam e Seik o Dais y Sylvi a
M I
Stati on
M . L.
Grill
B .
Coun ter Pantr y
G ende r F
Stat us
Bday
Add
S
F
S
F
S
29-Jan87 25Dec-88 25-Oct89
Malaria, Caloocan Sto. Cristo, CSJDM Muzon, CSJDM
Contact No 0919123 4567 0919723 6543 0919781 1311
OR 1. Display all fields where Station is equal to dining or counter. SELECT * FROM emp_info WHERE Station='Dining' OR Station='Counter'; En o
Lname
Fnam e
M I
Stati on
G ende r
Stat us
Bday
Add
Contact No
E 221 E 222 E 210 E 213 E 215 E 207 E 224 E 225 E 227
Ignacio
Daisy
L.
Co Doming uez Castro
Jackiel yn Joaqui n Jeffrey
D . T.
Santos
Yla
Dizon
Elaine
Aman
Charis se Cristin e Ariel
Camus Dizon
C . D . L. S . C . M .
Coun ter Coun ter Dinin g Dinin g Coun ter Coun ter Dinin g Coun ter Dinin g
F
S
F
S
M
S
M
S
F
S
F
S
F
S
F
S
M
S
25Dec-88 26-Apr87 13-Jan90 01-Feb90 26May-91 02Dec-89 12-Jun91 23-Sep88 27-Nov90
Sto. Cristo, CSJDM Tungkong Mangga, CSJDM Palmera Homes, CSJDM Palmera Homes, CSJDM Palmera Homes, CSJDM Francisco Homes, CSJDM Palmera Homes,CSJDM Francisco Homes, CSJDM Francisco Homes, CSJDM
0919723 6543 0929874 3128 0919281 1379 0908461 3365 0928593 3271 0922897 6573 0922455 3255 0918672 3552 0919876 1123
2. Display all fields where last name is Santos or Reyes. SELECT * FROM emp_info WHERE Lname='Santos' OR Lname='Reyes'; En o E 212 E 109 E 215 E 201 E 208 E 206 E 226
L nam e Sant os Sant os Sant os Reye s Reye s Sant os Reye s
Fname
M I
Statio n
Edison
T.
Evelyn
B . D . M . D . P.
Yla Jan Michael Jaime Harry Cory
G .
Stat us
Bday
Add
Fry
G ende r M
S
Sta. Maria, Bulacan
SC
F
M
Counte r Backup Grill
F
S
M
S
M
S
M
S
F
S
15-Feb88 17-Feb80 26May-91 15-Jan89 04-Mar88 15-Aug90 01-Oct90
Stock man Grill
Tungkong Mangga, CSJDM Palmera Homes, CSJDM Palmera Homes, CSJDM Muzon, CSJDM Francisco Homes, CSJDM Francisco Homes, CSJDM
Contact No 0928345 8765 0917658 3489 0928593 3271 0928778 6711 0915775 3821 0909357 8877 0922876 1222
3. Display all fields where contact number starts with 0917 or 0916. SELECT * FROM emp_info WHERE ContactNo like '0917*' OR ContactNo like '0916*'; En o
Lnam e
E 109 E 214 E 220
Santo s Salaza r Menes es
F nam e Evely n Mich ael Donn a
M I
Stati on
B . J.
SC
C .
Backup SC
G ende r F
Stat us
Bday
Add
M
M
S
Tungkong Mangga, CSJDM Gumaoc, CSJDM
F
S
17-Feb80 19Aug-90 17-Mar89
Tungkong Mangga, CSJDM
Contact No 0917658 3489 0916889 7656 0917889 6543
4. Display all fields where station is Soda or status is married. SELECT * FROM emp_info WHERE Station='Soda' OR Status= 'M'; En o E 167
L nam e Arroy o
F nam e Aster
M I
Stati on
A .
PC
G ende r M
Stat us
Bday
Add
M
29-Nov80
Francisco Homes, CSJDM
Contact No 0922567 8112
E 216 E 223 E 109 E 115
Hebr on Blaz a Sant os M agat
Robi n Kimp ee Evely n Ryza
C . E . B . U .
Soda
M
S
Soda
M
S
SC
F
M
PC
F
M
08-Aug89 16-Apr89 17-Feb80 27May-84
Francisco Homes, CSJDM Muzon, CSJDM Tungkong Mangga, CSJDM Palmera Homes, CSJDM
0928145 3567 0908765 8771 0917658 3489 0920987 4564
5. Display all fields where last name starts with D or first name starts with E. SELECT * FROM emp_info WHERE Lname like 'D*' OR Fname like 'E*'; En o
Lname
E 212 E 109 E 210 E 207 E 227
Santos Santos Doming uez Dizon Dizon
F nam e Ediso n Evely n Joaqu in Elain e Ariel
M I
Stati on
T. B . T. L. M .
Stat us
Bday
Add
Fry
G ende r M
S
Sta. Maria, Bulacan
SC
F
M
Dinin g Coun ter Dinin g
M
S
F
S
M
S
15-Feb88 17-Feb80 13-Jan90 02Dec-89 27Nov-90
Tungkong Mangga, CSJDM Palmera Homes, CSJDM Francisco Homes, CSJDM Francisco Homes, CSJDM
Contact No 0928345 8765 0917658 3489 0919281 1379 0922897 6573 0919876 1123
6. Display all fields where address starts with T or M. SELECT * FROM emp_info WHERE Add like 'T*' OR Add like 'M*'; En o
Lnam e
Fnam e
M I
Stati on
E 203 E 223 E 109 E 222 E 220 E 208 E 211 E 219
Ito
Seiko
Blaza
Kimpe e Evelyn
M . E . B . D . C . D . B . C .
Santo s Co Menes es Reyes
Jackiel yn Donna Jaime
Sayco
Sylvia
Sorio
Micha el
Stat us
Bday
Add
Grill
G ende r F
S
Malaria, Caloocan
Soda
M
S
SC
F
M
Count er SC
F
S
F
S
Grill
M
S
Pantr y Backup
F
S
M
S
29-Jan87 16-Apr89 17-Feb80 26-Apr87 17-Mar89 04-Mar88 25-Oct89 25Dec-90
Muzon, CSJDM Tungkong Mangga, CSJDM Tungkong Mangga, CSJDM Tungkong Mangga, CSJDM Muzon, CSJDM Muzon, CSJDM Muzon, CSJDM
Contact No 0919123 4567 0908765 8771 0917658 3489 0929874 3128 0917889 6543 0915775 3821 0919781 1311 0918671 1223
7. Display all fields where station equals Back-up or Stockman. SELECT * FROM emp_info WHERE Station='Back-up' OR Station='Stockman'; En o
Lnam e
Fname
M I
Statio n
E 214 E 201 E
Salaza r Reyes
Michael
J.
Jan Michael Ariel
M . M
Backup Backup Stock
Tolenti
G ende r M
Stat us
Bday
Add
S
Gumaoc, CSJDM
M
S
M
S
19Aug-90 15-Jan89 18-Apr-
Palmera Homes, CSJDM Sapang Palay,
Contact No 0916889 7656 0928778 6711 0919751
218 E 219 E 206
no Sorio Santo s
. C . P.
Michael Harry
man Backup Stock man
M
S
M
S
89 25Dec-90 15Aug-90
Bulacan Muzon, CSJDM
1232 0918671 1223 0909357 8877
Francisco Homes, CSJDM
NOT 1. Display all fields where status is not single. SELECT * FROM emp_info WHERE NOT (Status= 'S'); En o E 167 E 109 E 115
L nam e Arro yo Sant os M agat
F nam e Aster Evel yn Ryza
M I
Stati on
Stat us
Bday
Add
PC
G ende r M
A . B . U .
M
SC
F
M
PC
F
M
29-Nov80 17-Feb80 27May-84
Francisco Homes, CSJDM Tungkong Mangga, CSJDM Palmera Homes, CSJDM
Contact No 0922567 8112 0917658 3489 0920987 4564
2. Display all fields where Station is not counter and not dining. SELECT * FROM emp_info WHERE (NOT (Station= 'Counter')) AND (NOT (Station='Dining')); En o
Lnam e
Fname
M I
Statio n
E 167 E 203 E 216 E 223 E 212 E 109 E 115 E 209 E 214 E 201 E 220 E 208 E 211 E 217 E 202 E 218 E 219 E 204 E 206
Arroyo
Aster
Ito
Seiko
Hebro n Blaza
Robin
A . M . C . E . T.
Kimpee
Santo s Santo s Magat
Evelyn
Bedeo
Carla
Salaza r Reyes
Michael
Menes es Reyes
Edison
Ryza
Jan Michael Donna Jaime
Sayco
Sylvia
Cabili n Saizon
Mary
Tolenti no Sorio Estrell a Santo s
Carlo Ariel Michael Allan Harry
B . U . M . J. M . C . D . B . P. E . M . C . A . P.
Stat us
Bday
Add
PC
G ende r M
M
Grill
F
S
Francisco Homes, CSJDM Malaria, Caloocan
Soda
M
S
Soda
M
S
Fry
M
S
SC
F
M
PC
F
M
Pantry
F
S
Backup Backup SC
M
S
M
S
F
S
Grill
M
S
Pantry
F
S
Pantry
F
S
Fry
M
S
Stock man Backup Grill
M
S
M
S
M
S
Stock man
M
S
29-Nov80 29-Jan87 08-Aug89 16-Apr89 15-Feb88 17-Feb80 27May-84 13-Jun87 19-Aug90 15-Jan89 17-Mar89 04-Mar88 25-Oct89 31-Oct90 11-Nov89 18-Apr89 25Dec-90 15-Jul90 15-Aug90
Francisco Homes, CSJDM Muzon, CSJDM Sta. Maria, Bulacan Tungkong Mangga, CSJDM Palmera Homes, CSJDM Francisco Homes, CSJDM Gumaoc, CSJDM Palmera Homes, CSJDM Tungkong Mangga, CSJDM Muzon, CSJDM Muzon, CSJDM Sapang Palay, Bulacan Francisco Homes, CSJDM Sapang Palay, Bulacan Muzon, CSJDM Francisco Homes, CSJDM Francisco Homes, CSJDM
Contact No 0922567 8112 0919123 4567 0928145 3567 0908765 8771 0928345 8765 0917658 3489 0920987 4564 0909876 3456 0916889 7656 0928778 6711 0917889 6543 0915775 3821 0919781 1311 0935787 1121 0918761 1375 0919751 1232 0918671 1223 0919892 3675 0909357 8877
E 226 E 228
Reyes
Cory
Castro
Jelaine
G . D .
Grill
F
S
Pantry
F
S
01-Oct90 26May-88
Francisco Homes, CSJDM Palmera Homes, CSJDM
0922876 1222 0918375 6511
3. Display all fields where Address does not start with F and P. SELECT * FROM emp_info WHERE NOT(Add like 'F*') AND NOT(Add like 'P*'); En o
Lnam e
Fnam e
M I
Statio n
E 203 E 223 E 212 E 109 E 221 E 222 E 214 E 220 E 208 E 211 E 217 E 218 E 219
Ito
Seiko
Blaza
Kimpe e Edison
M . E . T.
Santo s Santo s Ignaci o Co Salaza r Menes es Reyes
Evelyn Daisy Jackiel yn Micha el Donna Jaime
Sayco
Sylvia
Cabili n Tolenti no Sorio
Mary Ariel Micha el
B . L. D . J. C . D . B . P. M . C .
Stat us
Bday
Add
Grill
G ende r F
S
Malaria, Caloocan
Soda
M
S
Fry
M
S
SC
F
M
Counte r Counte r Backup SC
F
S
F
S
M
S
F
S
Grill
M
S
Pantry
F
S
Pantry
F
S
Stock man Backup
M
S
M
S
29-Jan87 16-Apr89 15-Feb88 17-Feb80 25Dec-88 26-Apr87 19Aug-90 17-Mar89 04-Mar88 25-Oct89 31-Oct90 18-Apr89 25Dec-90
Muzon, CSJDM Sta. Maria, Bulacan Tungkong Mangga, CSJDM Sto. Cristo, CSJDM Tungkong Mangga, CSJDM Gumaoc, CSJDM Tungkong Mangga, CSJDM Muzon, CSJDM Muzon, CSJDM Sapang Palay, Bulacan Sapang Palay, Bulacan Muzon, CSJDM
Contact No 0919123 4567 0908765 8771 0928345 8765 0917658 3489 0919723 6543 0929874 3128 0916889 7656 0917889 6543 0915775 3821 0919781 1311 0935787 1121 0919751 1232 0918671 1223
4. Display all fields where last name does not have the letter S in it. SELECT * FROM emp_info WHERE NOT(Lname like '*S*'); En o
Lname
Fnam e
M I
Statio n
E 167 E 203 E 216 E 223 E 115 E 221 E 222 E 209 E 210
Arroyo
Aster
Ito
Seiko
Hebron
Robin
Blaza Magat
Kimpe e Ryza
Ignacio
Daisy
A . M . C . E . U . L.
Co Bedeo
Jackiel yn Carla
Doming uez
Joaqui n
D . M . T.
Stat us
Bday
Add
PC
G ende r M
M
Grill
F
S
Francisco Homes, CSJDM Malaria, Caloocan
Soda
M
S
Soda
M
S
PC
F
M
Counte r Counte r Pantry
F
S
F
S
F
S
Dining
M
S
29-Nov80 29-Jan87 08-Aug89 16-Apr89 27May-84 25Dec-88 26-Apr87 13-Jun87 13-Jan90
Francisco Homes, CSJDM Muzon, CSJDM Palmera Homes, CSJDM Sto. Cristo, CSJDM Tungkong Mangga, CSJDM Francisco Homes, CSJDM Palmera Homes, CSJDM
Contact No 0922567 8112 0919123 4567 0928145 3567 0908765 8771 0920987 4564 0919723 6543 0929874 3128 0909876 3456 0919281 1379
E 217 E 207 E 218 E 224 E 227
Cabilin
Mary
P.
Pantry
F
S
Dizon
Elaine
L.
F
S
Tolentin o Aman
Ariel
M . S . M .
Counte r Stock man Dining
M
S
F
S
Dining
M
S
Dizon
Charis se Ariel
31-Oct90 02Dec-89 18-Apr89 12-Jun91 27-Nov90
Sapang Palay, Bulacan Francisco Homes, CSJDM Sapang Palay, Bulacan Palmera Homes,CSJDM Francisco Homes, CSJDM
0935787 1121 0922897 6573 0919751 1232 0922455 3255 0919876 1123
5. Display all fields where last name does not contain S and Station is not dining or counter. SELECT * FROM emp_info WHERE NOT(Lname like '*S*') AND NOT(Station='Dining' OR Station='Counter'); En o
Lnam e
E 167 E 203 E 216 E 223 E 115 E 209 E 217 E 218
Arroyo
F nam e Aster
Ito
Seiko
Hebro n Blaza Magat
Robi n Kimp ee Ryza
Bedeo
Carla
Cabili n Tolenti no
Mary Ariel
M I
Statio n
A . M . C . E . U . M . P. M .
Stat us
Bday
Add
PC
G ende r M
M
Grill
F
S
Francisco Homes, CSJDM Malaria, Caloocan
Soda
M
S
Soda
M
S
PC
F
M
Pantry
F
S
Pantry
F
S
Stock man
M
S
29-Nov80 29-Jan87 08-Aug89 16-Apr89 27May-84 13-Jun87 31-Oct90 18-Apr89
Francisco Homes, CSJDM Muzon, CSJDM Palmera Homes, CSJDM Francisco Homes, CSJDM Sapang Palay, Bulacan Sapang Palay, Bulacan
Contact No 0922567 8112 0919123 4567 0928145 3567 0908765 8771 0920987 4564 0909876 3456 0935787 1121 0919751 1232
6. Display all fields where birth year is not from 1988 to 1990. SELECT * FROM emp_info WHERE Not(Bday>=#1/1/88# AND Bday<=#12/31/90#); En o E 167 E 203 E 115 E 222 E 209 E 215 E 224
L nam e Arro yo Ito
Fnam e
M I
Stati on
Aster
M agat Co
Ryza
A . M . U . D . M . D . S .
Bede o Sant os A man
Seiko
Jackiel yn Carla Yla Charis se
Stat us
Bday
Add
PC
G ende r M
M
Grill
F
S
Francisco Homes, CSJDM Malaria, Caloocan
PC
F
M
Coun ter Pantr y Coun ter Dinin g
F
S
F
S
F
S
F
S
29-Nov80 29-Jan87 27May-84 26-Apr87 13-Jun87 26May-91 12-Jun91
Palmera Homes, CSJDM Tungkong Mangga, CSJDM Francisco Homes, CSJDM Palmera Homes, CSJDM Palmera Homes,CSJDM
Contact No 0922567 8112 0919123 4567 0920987 4564 0929874 3128 0909876 3456 0928593 3271 0922455 3255
7. Display all fields where Station is dining but address does not start with F. SELECT * FROM emp_info WHERE Station='Dining' AND NOT(Add like 'F*'); En o
Lname
Fnam e
M I
Stati on
G ende r
Stat us
Bday
Add
Contact No
E 210 E 213 E 224
Doming uez Castro
Joaqui n Jeffrey
Aman
Charis se
T. C . S .
Dinin g Dinin g Dinin g
M
S
M
S
F
S
13-Jan90 01-Feb90 12-Jun91
Palmera Homes, CSJDM Palmera Homes, CSJDM Palmera Homes,CSJDM
0919281 1379 0908461 3365 0922455 3255
COMBINATION 1. Display all fields where station is not Dining and Counter, Address does not start with F and Gender is female. SELECT * FROM emp_info WHERE (NOT (Station= 'Counter')) AND (NOT (Station='Dining')) AND (NOT(Add like 'F*')) AND Gender='F' ; En o
Lnam e
E 203 E 109 E 115 E 220 E 211 E 217 E 228
Ito
F nam e Seik o Evel yn Ryza
Santo s Magat Menes es Sayco Cabili n Castro
M I
Stati on
Stat us
Bday
Add
Grill
G ende r F
D onna Sylvi a Mary
M . B . U . C . B . P.
S
Malaria, Caloocan
SC
F
M
PC
F
M
SC
F
S
Pantr y Pantr y Pantr y
F
S
F
S
F
S
29-Jan87 17-Feb80 27May-84 17-Mar89 25-Oct89 31-Oct90 26May-88
Jelai ne
D .
Tungkong Mangga, CSJDM Palmera Homes, CSJDM Tungkong Mangga, CSJDM Muzon, CSJDM Sapang Palay, Bulacan Palmera Homes, CSJDM
Contact No 0919123 4567 0917658 3489 0920987 4564 0917889 6543 0919781 1311 0935787 1121 0918375 6511
2. Display all fields where last name is Santos or Reyes but address does not start with F. SELECT * FROM emp_info WHERE (Lname='Santos' OR Lname='Reyes') AND (NOT(Add like 'F*')); En o E 212 E 109 E 215 E 201 E 208
L nam e Sant os Sant os Sant os Reye s Reye s
Fname
M I
Stati on
Edison
T.
Evelyn
B . D . M . D .
Yla Jan Michael Jaime
Stat us
Bday
Add
Fry
G ende r M
S
Sta. Maria, Bulacan
SC
F
M
Count er Backup Grill
F
S
M
S
M
S
15-Feb88 17-Feb80 26May-91 15-Jan89 04-Mar88
Tungkong Mangga, CSJDM Palmera Homes, CSJDM Palmera Homes, CSJDM Muzon, CSJDM
Contact No 0928345 8765 0917658 3489 0928593 3271 0928778 6711 0915775 3821
3. Display all fields where Station is Dining and Gender is Male but address does not start with F or Station is Pantry but address does not start with P. SELECT * FROM emp_info WHERE (Station='Dining' AND Gender='M' AND NOT(Add like'F*')) OR (Station='Pantry' AND NOT(Add like 'P*')); En o
Lname
E 209 E
Bedeo
F nam e Carla
Doming
Joaqu
M I
Stati on
M . T.
Pantr y Dinin
G ende r F
Stat us
Bday
Add
S
M
S
13-Jun87 13-Jan-
Francisco Homes, CSJDM Palmera Homes,
Contact No 0909876 3456 0919281
210 E 213 E 211 E 217
uez Castro Sayco Cabilin
in Jeffre y Sylvi a Mary
C . B . P.
g Dinin g Pantr y Pantr y
M
S
F
S
F
S
90 01-Feb90 25-Oct89 31-Oct90
CSJDM Palmera Homes, CSJDM Muzon, CSJDM Sapang Palay, Bulacan
1379 0908461 3365 0919781 1311 0935787 1121
4. Display all fields where birth year is 1988 but address does not start with P or birth year is 1988 and address start with F. SELECT * FROM emp_info WHERE ((Bday>=#1/1/88#) AND (Bday<=#12/31/88#) AND NOT(Add like 'P*')) OR ((Bday>=#1/1/88#) AND (Bday<=#12/31/88#) AND (Add like 'F*')); En o E 212 E 221 E 208 E 225
L nam e Sant os Igna cio Reye s C amu s
F nam e Ediso n Daisy
M I
Stati on
T.
Fry
L.
Jaime
D . C .
Coun ter Grill
Cristi ne
Coun ter
G ende r M
Stat us
Bday
Add
S
F
S
Sta. Maria, Bulacan Sto. Cristo, CSJDM
M
S
F
S
15-Feb88 25Dec-88 04-Mar88 23Sep-88
Muzon, CSJDM Francisco Homes, CSJDM
Contact No 0928345 8765 0919723 6543 0915775 3821 0918672 3552
5. Display all fields where Station is not Dining and birth year is 1990 and gender is male or Station is not Dining and birth year is 1988 and gender is male. SELECT * FROM emp_info WHERE (NOT(Station='Dining') AND (Bday>=#1/1/90# AND Bday<=#12/31/90#) AND Gender='M') OR (NOT(Station='Dining') AND (Bday>=#1/1/88# AND Bday<=#12/31/88#) AND Gender='M'); En o E 212 E 214 E 208 E 219 E 204 E 206
L nam e Sant os Salaz ar Reye s Sorio Estre lla Sant os
F nam e Ediso n Mich ael Jaime Mich ael Allan Harry
M I
Statio n
T.
Fry
J. D . C . A . P.
G ende r M
Stat us
Bday
Add
S
Backup Grill
M
S
Sta. Maria, Bulacan Gumaoc, CSJDM
M
S
Backup Grill
M
S
M
S
Stock man
M
S
15-Feb88 19Aug-90 04-Mar88 25Dec-90 15-Jul90 15Aug-90
Muzon, CSJDM Muzon, CSJDM Francisco Homes, CSJDM Francisco Homes, CSJDM
Contact No 0928345 8765 0916889 7656 0915775 3821 0918671 1223 0919892 3675 0909357 8877
6. Display all fields where Status is single and Gender is female and Station is counter or Status is single and Gender is male and Station is dining and Address does not start with P. SELECT * FROM emp_info WHERE (Status='S' AND Gender='F' AND Station='Counter') OR (Status='S' AND Gender='M' AND Station='Dining' AND NOT(Add like 'P*')); En o E 221 E 222
L nam e Igna cio Co
Fnam e
M I
Stati on
Daisy
L.
Jackiel yn
D .
Coun ter Coun ter
G ende r F
Stat us
Bday
Add
S
Sto. Cristo, CSJDM
F
S
25Dec-88 26-Apr87
Tungkong Mangga, CSJDM
Contact No 0919723 6543 0929874 3128
E 215 E 207 E 225 E 227
Sant os Dizo n C amu s Dizo n
Yla Elaine
D . L.
Cristin e
C .
Coun ter Coun ter Coun ter
Ariel
M .
Dinin g
F
S
F
S
F
S
M
S
26May-91 02Dec-89 23-Sep88
Palmera Homes, CSJDM Francisco Homes, CSJDM Francisco Homes, CSJDM
0928593 3271 0922897 6573 0918672 3552
27-Nov90
Francisco Homes, CSJDM
0919876 1123
7. Display all fields where last name starts with S and Gender is male and Station is not fry or last name starts with A and Gender is male. SELECT * FROM emp_info WHERE (Lname like 'S*' AND Gender='M' AND NOT(Station='Fry')) OR (Lname like 'A*' AND Gender='M'); En o E 167 E 214 E 219 E 206
L nam e Arroy o Salaz ar Sorio Sant os
F nam e Aster Mich ael Mich ael Harry
M I
Statio n
A . J.
PC Backup Backup Stock man
C . P.
G ende r M
Stat us
Bday
Add
M
M
S
Francisco Homes, CSJDM Gumaoc, CSJDM
M
S
M
S
29Nov-80 19Aug-90 25Dec-90 15Aug-90
Muzon, CSJDM Francisco Homes, CSJDM
Contact No 0922567 8112 0916889 7656 0918671 1223 0909357 8877
8. Display all fields where first name starts with J but address does not start with P or first name starts with J and station is dining. SELECT * FROM emp_info WHERE (Fname like 'J*' AND NOT(Add like 'P*')) OR (Fname like 'J*' AND Station='Dining'); En o
Lname
Fnam e
M I
Stati on
E 222 E 210 E 213 E 208
Co Doming uez Castro
Jackiel yn Joaqui n Jeffrey
D . T.
Reyes
Jaime
Coun ter Dinin g Dinin g Grill
C . D .
G ende r F
Stat us
Bday
Add
S
M
S
M
S
M
S
26-Apr87 13-Jan90 01-Feb90 04Mar-88
Tungkong Mangga, CSJDM Palmera Homes, CSJDM Palmera Homes, CSJDM Muzon, CSJDM
Contact No 0929874 3128 0919281 1379 0908461 3365 0915775 3821
9. Display all fields where Station is Grill and Gender is male or Station is Soda but address does not start with F. SELECT * FROM emp_info WHERE (Station='Grill' AND Gender='M') OR (Station='Soda' AND NOT(Add like 'F*')); En o E 223 E
L nam e Blaza Reye
F nam e Kimp ee Jaime
M I
Stati on
Stat us
Bday
Add
Soda
G ende r M
E . D
S
Muzon, CSJDM
Grill
M
S
16-Apr89 04-
Muzon, CSJDM
Contact No 0908765 8771 0915775
208 E 204
s Estre lla
Allan
. A .
Grill
M
S
Mar-88 15-Jul90
Francisco Homes, CSJDM
3821 0919892 3675