Spreadsheet: 682445d1592112765-find-date-of-which-employee-satisfies-two-conditions-sample-2
Sheet: NBD

FLAG | ORDER-NO | DOC1 | DOC2 | NAME | PREM | PLAN | MODE | DOB | EM-CODE | DO | GC |  | COUNT | PREM
XB | 354533573 | 20190425 | 4444444 | XXXXX | 9315 | XXXXX | XXXXX | 19930401 | 192 | A0XX | Y |  | 1
XB | 355025334 | 20190611 | 4444444 | XXXXX | 11971 | XXXXX | XXXXX | 20180518 | 192 | A0XX | Y |  | 2
XB | 355025533 | 20190624 | 4444444 | XXXXX | 9344 | XXXXX | XXXXX | 20180518 | 192 | A0XX | Y |  |  |  | NOT ELIGIBLE
XB | 353033663 | 20190628 | 4444444 | XXXXX | 2572 | XXXXX | XXXXX | 19800121 | 192 | A0XX | Y |  | 3 |  | NOT COMPLETED 6 ORDERS WITH UNIQUE DOB
XB | 355040436 | 20190728 | 4444444 | XXXXX | 12290 | XXXXX | XXXXX | 19800121 | 192 | A0XX | Y
XB | 356553753 | 20190828 | 4444444 | XXXXX | 12723 | XXXXX | XXXXX | 19860120 | 192 | A0XX | Y |  | 4
XB | 353452233 | 20190828 | 4444444 | XXXXX | 55371 | XXXXX | XXXXX | 19870111 | 192 | A0XX | Y |  | 5
XB | 353452300 | 20190828 | 4444444 | XXXXX | 22536 | XXXXX | XXXXX | 19870111 | 192 | A0XX | Y
XB | 356554447 | 20191015 | 4444444 | XXXXX | 25000 | XXXXX | XXXXX | 19770601 | 727 | A0XX | Y |  | 1 |  | ELIGIBLE(PREM >=50000 CONDITION FULFILED ON 20200128 BUT 6 ORDERS WITH UNIQUE DOB FULFILLED ON 20200130 SO DATE THAT SHOU DISPLAY IS 20200130)
XB | 357657557 | 20191127 | 4444444 | XXXXX | 5317 | XXXXX | XXXXX | 19770601 | 727 | A0XX | Y
XB | 357657553 | 20191127 | 4444444 | XXXXX | 3915 | XXXXX | XXXXX | 20030810 | 727 | A0XX | Y |  | 2 |  | COMPLETED 6 ORDERS WITH UNIQUE DOB AND PREM >=50000 ON 20200130
XB | 353452230 | 20200115 | 4444444 | XXXXX | 6533 | XXXXX | XXXXX | 19980911 | 727 | A0XX | Y |  | 3
XB | 353452235 | 20200115 | 4444444 | XXXXX | 10991 | XXXXX | XXXXX | 19920626 | 727 | A0XX | Y |  | 4
XB | 353452754 | 20200128 | 4444444 | XXXXX | 11637 | XXXXX | XXXXX | 19761201 | 727 | A0XX | Y |  | 5
XB | 353452759 | 20200130 | 4444444 | XXXXX | 40000 | XXXXX | XXXXX | 19760601 | 727 | A0XX | Y |  | 6
XB | 353033763 | 20200214 | 4444444 | XXXXX | 1937 | XXXXX | XXXXX | 19840601 | 727 | A0XX | Y |  | 7
XB | 354533575 | 20190425 | 4444444 | XXXXX | 9923 | XXXXX | XXXXX | 19780601 | 888 | A0XX | Y |  | 1
XB | 354533579 | 20190429 | 4444444 | XXXXX | 9923 | XXXXX | XXXXX | 19780601 | 888 | A0XX | Y |  |  |  | ELIGIBLE 0N 20190604(BOTH CONDITION FULFILED ON 20190604)
XB | 354533578 | 20190424 | 4444444 | XXXXX | 9923 | XXXXX | XXXXX | 19720605 | 888 | A0XX | Y |  | 2
XB | 355025036 | 20190522 | 4444444 | XXXXX | 500 | XXXXX | XXXXX | 19910101 | 888 | A0XX | Y |  | 3 |  | COMPLETED 6 ORDERS WITH UNIQUE DOB AND PREM >=50000 ON 20190604
XB | 355025046 | 20190524 | 4444444 | XXXXX | 1091 | XXXXX | XXXXX | 19910501 | 888 | A0XX | Y |  | 4 |  | (COMPLETED 6 ORDERS WITH UNIQUE DOB ON  ON 20190528 BUT Prem >=50000 condition was fulfiled on 20190604)
XB | 355025535 | 20190528 | 4444444 | XXXXX | 2673 | XXXXX | XXXXX | 19800704 | 888 | A0XX | Y |  | 5
XB | 355025555 | 20190528 | 4444444 | XXXXX | 1500 | XXXXX | XXXXX | 19890101 | 888 | A0XX | Y |  | 6
XB | 355025274 | 20190604 | 4444444 | XXXXX | 25000 | XXXXX | XXXXX | 19680101 | 888 | A0XX | Y |  | 7
XB | 355025453 | 20190614 | 4444444 | XXXXX | 43758 | XXXXX | XXXXX | 19720601 | 888 | A0XX | Y
XB | 355040073 | 20190715 | 4444444 | XXXXX | 1313 | XXXXX | XXXXX | 19720601 | 888 | A0XX | Y
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1