By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
version() |
---|
5.7.29 |
id | date_hour | speed | name | nor | validation | p_i | speed_performance |
---|---|---|---|---|---|---|---|
1 | 2018-02-03 13:23:00 | -12.3 | SYN | 10 | 1 | 3 | 4 |
2 | 2018-02-03 11:23:00 | -6.36 | SYN | 13 | 0 | 4 | 5 |
3 | 2018-02-03 01:23:00 | -26.36 | SYN | 24 | 0 | 2 | 4 |
4 | 2020-04-06 21:23:00 | -156.36 | SYN | 16 | 1 | 3 | 6 |
5 | 2020-04-06 03:23:00 | -36.36 | YRT | 136 | 0 | 2 | 5 |
6 | 2020-04-06 12:23:00 | -16.36 | SYN | 13 | 1 | 4 | 4 |