By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
7 rows affected
visitor | visit_id | visit_time | val | purchase | percent_val |
---|---|---|---|---|---|
1 | 1002 | 2020-01-02 11:00:00.000 | 0.97 | True | 0.2231 |
1 | 1003 | 2020-01-02 14:00:00.000 | 0.55 | True | 0.122705 |
2 | 2001 | 2020-01-01 10:00:00.000 | 0.11 | True | 0.11 |
2 | 2004 | 2020-01-11 14:00:00.000 | 0.38 | True | 0.034656 |