Error in query SELECT count(prf_ID) as Number, if (prf_Units = 'Meter', round(ABS(prf_MinRate),0) , round(ABS(prf_MinRate) * 0.3048, 0)) as DescentRate, if (prf_Units = 'Meter', round(ABS(prf_MaxRate),0) , round(ABS(prf_MaxRate) * 0.3048, 0)) as AscentRate FROM udlProfile WHERE usr_ID = 1 AND prf_Type = 'depth' GROUP BY prf_MinRate, prf_MaxRate
Max stijgsnelheden
Snelheid(Meter/min):Aantal duiken%
0: 8 1%
1: 8 1%
2: 47 3%
3: 164 12%
4: 347 26%
5: 236 17%
6: 173 13%
7: 98 7%
8: 115 8%
9: 57 4%
10: 34 3%
11: 20 1%
12: 15 1%
13: 7 1%
14: 4 0%
15: 4 0%
16: 5 0%
17: 3 0%
18: 2 0%
19: 3 0%
20: 4 0%
21: 2 0%
22: 1 0%
23: 1 0%
24: 0 0%
25: 0 0%
26: 0 0%
27: 0 0%
28: 1 0%
29: 0 0%
30: 0 0%
31: 0 0%
32: 0 0%
33: 0 0%
34: 0 0%
35: 0 0%
36: 0 0%
37: 0 0%
38: 0 0%
39: 0 0%
40: 0 0%
41: 0 0%
42: 0 0%
43: 0 0%
44: 1 0%
Opstijgsnelheid buckets
Max daalsnelheden
Snelheid(Meter/min):Aantal duiken%
0: 7 1%
1: 11 1%
2: 30 2%
3: 79 6%
4: 254 19%
5: 204 15%
6: 182 13%
7: 106 8%
8: 108 8%
9: 60 4%
10: 44 3%
11: 37 3%
12: 39 3%
13: 32 2%
14: 34 3%
15: 18 1%
16: 41 3%
17: 9 1%
18: 15 1%
19: 9 1%
20: 11 1%
21: 6 0%
22: 2 0%
23: 7 1%
24: 6 0%
25: 2 0%
26: 1 0%
27: 1 0%
28: 0 0%
29: 0 0%
30: 1 0%
31: 0 0%
32: 1 0%
33: 0 0%
34: 0 0%
35: 1 0%
36: 1 0%
37: 0 0%
38: 0 0%
39: 1 0%
Afdaalsnelheid buckets
Opstijg versus Afdaal snelheden