1-Please highlight all Female staff and have function as Admin or Finance and h

ID Name Sex Function Join Date Location

1 Chhoem Chanty M Admin 6/6/2015 PP
2 Mas Kunthea F Accountant 6/7/2018 PV
3 Saran Channy F Finance 1/8/2009 PP
4 Tin Samnang F Admin 6/9/2015 TK
5 Son Chan Sem M Seller 6/10/2012 PP
6 Vanna Vanny F Marketing 6/11/2018 PV
7 Phat Raksmey M Tax Officer 6/12/2019 KS
8 Chin Choeun F S-Accountant 6/13/2019 KS
9 Khem Somaly M Marketing 6/14/2015 TK
10 Chhem Bonreth F Admin 12/15/2010 PP
11 Choem Sokhon M Finance 6/16/2020 TK
12 Kun Sreimoch M GM 6/17/2018 TK
13 Kun Solai F Finance 6/18/2010 PP
14 Bean Hong F Admin 6/19/2012 PP
15 Men Pisey M Marketing 6/20/2010 KS
16 Choem Srey Mach F Seller 6/21/2018 PP
17 Chanthorn Sreyrath F Admin 6/22/2011 PV
18 Pean Tola F Marketing 6/23/2018 PV
19 Han Seanghong M Tax Officer 1/24/2016 TK
20 Kim Leng M Marketing 6/25/2017 KS
min or Finance and have salary 1000$ up

Salaries
$ 652.00
$ 350.00
$ 1,200.00
$ 850.00
$ 250.00
$ 2,500.00
$ 800.00
$ 1,200.00
$ 680.00
$ 1,500.00
$ 880.00
$ 2,200.00
$ 2,000.00
$ 580.00
$ 850.00
$ 3,000.00
$ 1,500.00
$ 520.00
$ 600.00
$ 850.00
nd have salary 1000$ up?
 2- Please Highlight all staff that have salary between 800$ to 3000$?
ID Name Sex Function Join Date Location
1 Chhoem Chanty M Admin 6/6/2015 PP
2 Mas Kunthea F Accountant 6/7/2018 PV
3 Saran Channy F Finance 1/8/2009 PP
4 Tin Samnang F Admin 6/9/2015 TK
5 Son Chan Sem M Seller 6/10/2012 PP
6 Vanna Vanny M Marketing 6/11/2018 PV
7 Phat Raksmey M Tax Officer 6/12/2019 KS
8 Chin Choeun F S-Accountangt 6/13/2019 KS
9 Khem Somaly M Marketing 6/14/2015 TK
10 Chhem Bonreth F Admin 12/15/2010 PP
11 Choem Sokhon M Finance 6/16/2020 TK
12 Kun Sreimoch M GM 6/17/2018 TK
13 Kun Solai F Finance 6/18/2010 PP
14 Bean Hong F Admin 6/19/2012 PP
15 Men Pisey M Marketing 6/20/2010 KS
16 Choem Srey Mach F Seller 6/21/2018 PP
17 Chanthorn Sreyrath F Admin 6/22/2011 PV
18 Pean Tola F Marketing 6/23/2018 PV
19 Han Seanghong M Tax Officer 1/24/2016 TK
20 Kim Leng M Marketing 6/25/2017 KS
to 3000$?
Salaries
$ 652.00
$ 350.00
$ 1,500.00
$ 650.00
$ 250.00
$ 2,500.00
$ 750.00
$ 1,200.00
$ 680.00
$ 1,500.00
$ 500.00
$ 850.00
$ 500.00
$ 900.00
$ 790.00
$ 3,000.00
$ 1,500.00
$ 520.00
$ 600.00
$ 850.00
 1 Hightlight all staff that work for company from 5 years and 6 mo
ID Name Sex Function Join Date
1 Chhoem Chanty M Admin Assistant 6/6/2020
2 Mas Kunthea F Accountant 6/7/2018
3 Saran Channy F Finance Manager 1/8/2009
4 Tin Samnang F Admin Manager 6/9/2019
5 Son Chan Sem M Seller 6/10/2012
6 Vanna Vanny M Marketing 6/11/2018
7 Phat Raksmey M Tax Officer 6/12/2019
8 Chin Choeun F S-Accountangt 6/13/2019
9 Khem Somaly M Marketing 6/14/2015
10 Chhem Bonreth F Admin Officer 12/15/2010
11 Choem Sokhon M Finance Assistant 6/16/2020
12 Kun Sreimoch M GM 6/17/2018
13 Kun Solai F Finance 6/18/2018
14 Bean Hong F Admin Assistant 6/19/2012
15 Men Pisey M Marketing 6/20/2017
16 Choem Srey Mach F Seller 6/21/2018
17 Chanthorn Sreyrath F Admin HR 6/22/2011
18 Pean Tola F Marketing 6/23/2018
19 Han Seanghong M Finance Assistant 1/24/2016
20 Kim Leng M Marketing 6/25/2017
rom 5 years and 6 months up?
Location Salaries

PP $ 652.00
PV $ 350.00
PP $ 1,500.00
TK $ 650.00
PP $ 250.00
PV $ 2,500.00
KS $ 800.00
KS $ 1,200.00
TK $ 680.00
PP $ 1,500.00
TK $ 880.00
TK $ 2,200.00
PP $ 2,000.00
PP $ 10.00
KS $ 850.00
PP $ 3,000.00
PV $ 1,500.00
PV $ 520.00
TK $ 600.00
KS $ 850.00
ID Name Sex Function Date of Birth Location

1 Chhoem Chanty M Admin Assistant 19-Nov-45 PP

2 Mas Kunthea F Accountant 21-Nov-71 PV
3 Saran Channy F Finance Manager 24-Jun-65 PP
4 Tin Samnang F Admin Manager 22-Nov-68 TK
5 Son Chan Sem M Seller 24-Nov-65 PP
6 Vanna Vanny M Marketing 25-Nov-60 PV
7 Phat Raksmey M Tax Officer 25-Nov-72 KS
8 Chin Choeun F S-Accountangt 26-Nov-67 KS
9 Khem Somaly M Marketing 27-Nov-68 TK
10 Chhem Bonreth F Admin Officer 30-May-64 PP
11 Choem Sokhon M Finance Assistant 30-Nov-73 TK
12 Kun Sreimoch M GM 1-Dec-58 TK
13 Kun Solai F Finance 2-Dec-63 PP
14 Bean Hong F Admin Assistant 3-Dec-75 PP
15 Men Pisey M Marketing 4-Dec-63 KS
16 Choem Srey Mach F Seller 5-Dec-71 PP
17 Chanthorn Sreyrat F Admin HR 5-Dec-64 PV
18 Pean Tola F Marketing 7-Dec-71 PV
19 Han Seanghong M Finance Assistant 9-Jul-69 TK
20 Kim Leng M Marketing 9-Dec-70 KS

1 Hightlight all staff that have two condition as bellow

-if male and retired at 60 Years
-if female and retired at 55 Years
 Salaries

$ 652.00
$ 350.00
$ 1,500.00
$ 650.00
$ 250.00
$ 2,500.00
$ 800.00
$ 1,200.00
$ 680.00
$ 1,500.00
$ 880.00
$ 2,200.00
$ 2,000.00
$ 10.00
$ 850.00
$ 3,000.00
$ 1,500.00
$ 520.00
$ 600.00
$ 850.00
1-Hightlight all staff that have function begining with Admin or Finan

ID Name Sex Function Join Date Location

1 Chhoem Chanty M Admin Assistant 6/6/2015 PP
2 Mas Kunthea F Accountant 6/7/2018 PV
3 Saran Channy F Finance Manager 1/8/2009 PP
4 Tin Samnang F Admin Manager 6/9/2015 TK
5 Son Chan Sem M Seller 6/10/2012 PP
6 Vanna Vanny M Marketing 6/11/2018 PV
7 Phat Raksmey M Admin Officer 6/12/2019 KS
8 Chin Choeun F S-Accountant 6/13/2019 KS
9 Khem Somaly M Marketing 6/14/2015 TK
10 Chhem Bonreth F Admin Officer 12/15/2010 PP
11 Choem Sokhon M Finance Assistant 6/16/2020 TK
12 Kun Sreimoch M GM 6/17/2018 TK
13 Kun Solai F Finance 6/18/2010 PP
14 Bean Hong F Admin Assistant 6/19/2012 PP
15 Men Pisey M Marketing 6/20/2010 KS
16 Choem Srey Mach F Seller 6/21/2018 PP
17 Chanthorn Sreyrath F Admin HR 6/22/2011 PV
18 Pean Tola F Marketing 6/23/2018 PV
19 Han Seanghong M Finance Assistant 1/24/2016 TK
20 Kim Leng M Marketing 6/25/2017 KS
dmin or Finan?

Salaries
$ 652.00
$ 350.00
$ 1,500.00
$ 650.00
$ 250.00
$ 2,500.00
$ 800.00
$ 1,200.00
$ 680.00
$ 1,500.00
$ 880.00
$ 2,200.00
$ 2,000.00
$ 10.00
$ 850.00
$ 3,000.00
$ 1,500.00
$ 520.00
$ 600.00
$ 850.00