Conditions
- If Purchase Date are within the same day & they are within 2 hours
- Amount should be more than 2 $
Input | ||
---|---|---|
ID | Purchase Date | Amount |
0002 | 2021/04/01 08:13:00 | 2 |
0173 | 2021/03/29 13:52:00 | 65.86 |
0173 | 2021/04/01 13:23:00 | 47.68 |
0173 | 2021/04/01 15:22:00 | 74.72 |
0250 | 2021/03/29 10:46:00 | 70.02 |
0250 | 2021/03/31 11:33:00 | 46.03 |
0272 | 2021/04/01 09:45:00 | 36.03 |
0272 | 2021/04/01 09:45:00 | 10.5 |
Output | ||
ID | Purchase Date | Amount |
0173 | 2021/04/01 13:23:00 | 47.68 |
0173 | 2021/04/01 15:22:00 | 74.72 |
0272 | 2021/04/01 09:45:00 | 36.03 |
0272 | 2021/04/01 09:45:00 | 10.5 |