By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
1 rows affected
1 rows affected
1 rows affected
1 rows affected
1 rows affected
1 rows affected
1 rows affected
1 rows affected
1 rows affected
1 rows affected
1 rows affected
| ts | user_id | event | grp | rn_asc | rn_desc |
|---|---|---|---|---|---|
| 1500 | a | eat | 1 | 1 | 3 |
| 1501 | a | walk | 1 | 2 | 2 |
| 1502 | a | sleep | 1 | 3 | 1 |
| 1500 | b | eat | 1 | 1 | 2 |
| 1501 | b | sleep | 1 | 2 | 1 |
| 1500 | c | walk | 1 | 1 | 4 |
| 1502 | c | sit | 1 | 3 | 2 |
| 1503 | c | sleep | 1 | 4 | 1 |