By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
27 rows affected
Inst | Acct | First | MI | Last | Activty | ActivtyDate | lag_activity |
---|---|---|---|---|---|---|---|
1 | 1111111 | EDWARD | null | BICKLE | OptIn | 2019-05-25 12:02:00.000 | null |
1 | 1111111 | EDWARD | null | BICKLE | OptOut | 2019-06-20 11:57:00.000 | OptIn |
1 | 1111111 | EDWARD | null | BICKLE | OptIn | 2019-06-27 10:34:00.000 | OptOut |
1 | 1111111 | EDWARD | null | BICKLE | OptOut | 2019-06-27 10:35:00.000 | OptIn |
1 | 1111111 | KIM | null | BICKLE | OptIn | 2019-07-02 11:35:42.000 | OptOut |
1 | 1111111 | EDWARD | null | BICKLE | OptOut | 2019-07-05 15:04:00.000 | OptIn |
1 | 1111111 | EDWARD | null | BICKLE | OptIn | 2019-07-06 07:57:00.000 | OptOut |
0 | 2222222 | DAWN | M | ADAMS | OptOut | 2019-03-03 20:51:00.000 | null |
0 | 2222222 | DAWN | M | ADAMS | OptIn | 2019-03-08 19:10:00.000 | OptOut |
0 | 2222222 | DAWN | M | ADAMS | OptOut | 2019-03-18 16:21:00.000 | OptIn |
0 | 2222222 | DAWN | M | ADAMS | OptIn | 2019-03-21 16:38:00.000 | OptOut |
0 | 2222222 | DAWN | M | ADAMS | OptOut | 2019-03-22 05:26:00.000 | OptIn |
0 | 2222222 | DAWN | M | ADAMS | OptIn | 2019-04-01 15:39:00.000 | OptOut |
0 | 2222222 | DAWN | M | ADAMS | OptOut | 2019-04-02 04:06:00.000 | OptIn |
0 | 2222222 | DAWN | M | ADAMS | OptIn | 2019-04-06 11:53:00.000 | OptOut |
0 | 2222222 | DAWN | M | ADAMS | OptOut | 2019-04-09 12:51:00.000 | OptIn |
0 | 2222222 | DAWN | M | ADAMS | OptIn | 2019-04-20 15:21:00.000 | OptOut |