Assign

  • May 2020
  • PDF

This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA


Overview

Download & View Assign as PDF for free.

More details

  • Words: 4,842
  • Pages: 12
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

Related Documents

Assign
May 2020 59
Assign
June 2020 55
Assign
May 2020 57
Assign
November 2019 79
Assign
November 2019 91
Assign)
June 2020 57