add batch remove batch split batch comment selection show hidden batches hide batch highlight batch
db<>fiddle
donate feedback about
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
name date_hr avg(nor) p_i
SYN 2018-02-03 18.5 null
SYN 2018-02-04 10 3
SYN 2020-04-07 14.5 3.5
YRT 2020-04-06 136 null