Spreadsheet: 682507d1592157992-find-date-of-which-employee-satisfies-two-conditions-sample-2
Sheet: NBD

1 | FLAG | ORDER-NO | DOC1 | DOC2 | NAME | PREM | PLAN | MODE | DOB | EM-CODE | DO | GC |  | COUNT | PREM
2 | XB | 356553753 | 20190228 | 4444444 | XXXXX | 200 | XXXXX | XXXXX | 19860120 | 192 | A0XX | Y | 5
3 | XB | 354533573 | 20190425 | 4444444 | XXXXX | 100 | XXXXX | XXXXX | 19930401 | 192 | A0XX | Y | 6 | 5
4 | XB | 355025334 | 20190611 | 4444444 | XXXXX | 200 | XXXXX | XXXXX | 19800112 | 192 | A0XX | Y | 3 | 3 |  | ELIGIBILITY DATE SHOULD BE 20190829(DATE ON WHICH BOTH CONDITIONS ARE SATISFIED)
5 | XB | 355025533 | 20190624 | 4444444 | XXXXX | 300 | XXXXX | XXXXX | 19800111 | 192 | A0XX | Y | 2 | 2 |  | (SATISFIES UNIQUE DOB ORDER CONDITION ON 20190828
6 | XB | 353033663 | 20190628 | 4444444 | XXXXX | 400 | XXXXX | XXXXX | 19800102 | 192 | A0XX | Y | 1 | 1 |  | BUT PREM>=50000 CONDITION WA SATISFIED ON 20190829)
7 | XB | 355040436 | 20190628 | 1111111c | XXXXX | 500 | XXXXX | XXXXX | 19800121 | 192 | A0XX | Y | 4 | 4
8 | XB | 353452233 | 20190927 | DOC2 | XXXXX | 50000 | XXXXX | XXXXX | 20190401 | 192 | A0XX | Y |  | 6
9 | XB | 353452300 | 20191028 | 4444444 | XXXXX | 200 | XXXXX | XXXXX | 19870110 | 192 | A0XX | Y |  | 7
10 | FLAG | ORDER-NO | DOC1 | DOC2 | NAME | PREM | PLAN | MODE | DOB | EM-CODE | DO | GC |  | COUNT | PREM
11 | XB | 353033763 | 20190101 | 4444444 | XXXXX | 1937 | XXXXX | XXXXX | 19840601 | 727 | A0XX | Y |  | 4
12 | XB | 356554447 | 20191015 | 4444444 | XXXXX | 25000 | XXXXX | XXXXX | 19770601 | 727 | A0XX | Y |  | 2
13 | XB | 357657557 | 20191127 | 4444444 | XXXXX | 5317 | XXXXX | XXXXX | 19770601 | 727 | A0XX | Y |  | 3
14 | XB | 357657553 | 20191127 | 4444444 | XXXXX | 3915 | XXXXX | XXXXX | 20030810 | 727 | A0XX | Y |  | 6
15 | XB | 353452235 | 20200115 | 4444444 | XXXXX | 10991 | XXXXX | XXXXX | 19920626 | 727 | A0XX | Y |  | 5
16 | XB | 353452230 | 20200115 | 4444444 | XXXXX | 6533 | XXXXX | XXXXX | 20030810 | 727 | A0XX | Y |  | 7 |  | ELIGIBILITY DATE SHOULD BE 20200128(DATE ON WHICH BOTH CONDITIONS ARE SATISFIED)
17 | XB | 353452759 | 20200203 | 4444444 | XXXXX | 40000 | XXXXX | XXXXX | 19760601 | 727 | A0XX | Y |  | 7
18 | XB | 353033763 | 20200214 | 4444444 | XXXXX | 1937 | XXXXX | XXXXX | 19760601 | 727 | A0XX | Y
19 | XB | 353452754 | 20201128 | 4444444 | XXXXX | 11637 | XXXXX | XXXXX | 19761201 | 727 | A0XX | Y |  | 1
20
21 | FLAG | ORDER-NO | DOC1 | DOC2 | NAME | PREM | PLAN | MODE | DOB | EM-CODE | DO | GC |  | COUNT | PREM
22 | XB | 354533578 | 20190424 | 4444444 | XXXXX | 9923 | XXXXX | XXXXX | 19720605 | 888 | A0XX | Y
23 | XB | 354533575 | 20190425 | 4444444 | XXXXX | 9923 | XXXXX | XXXXX | 19780601 | 888 | A0XX | Y |  | 2 |  | ELIGIBILITY DATE SHOULD BE 20190528(DATE ON WHICH BOTH CONDITIONS ARE SATISFIED)
24 | XB | 354533579 | 20190429 | 4444444 | XXXXX | 9923 | XXXXX | XXXXX | 19780601 | 888 | A0XX | Y |  | 3
25 | XB | 355025036 | 20190522 | 4444444 | XXXXX | 500 | XXXXX | XXXXX | 19910101 | 888 | A0XX | Y |  | 6
26 | XB | 355025046 | 20190524 | 4444444 | XXXXX | 1091 | XXXXX | XXXXX | 19910501 | 888 | A0XX | Y |  | 7
27 | XB | 355025535 | 20190528 | 4444444 | XXXXX | 2673 | XXXXX | XXXXX | 19800704 | 888 | A0XX | Y |  | 4
28 | XB | 355025555 | 20190528 | 4444444 | XXXXX | 25000 | XXXXX | XXXXX | 19890101 | 888 | A0XX | Y |  | 5
29 | XB | 355025274 | 20190604 | 4444444 | XXXXX | 25000 | XXXXX | XXXXX | 19680101 | 888 | A0XX | Y |  | 8
30 | XB | 355025453 | 20190614 | 4444444 | XXXXX | 43758 | XXXXX | XXXXX | 19720601 | 888 | A0XX | Y
31 | XB | 355040073 | 20190715 | 4444444 | XXXXX | 1313 | XXXXX | XXXXX | 19720601 | 888 | A0XX | Y |  | 1
32
33
34
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1