blob: ea9a06123ae0dc0420a3af9f278929175052ea15 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
|
a c sum(a)
1 a 1
2 b 2
3 c 3
4 E 4
5 C 5
6 D 6
a c sum(a)
sum(a)
NULL
a
1
3
6
5
2
4
a
1
3
6
5
2
4
count(distinct a) count(distinct grp)
6 3
count(distinct a) count(distinct grp)
6 3
sum(a) count(a) avg(a) std(a) bit_or(a) bit_and(a) min(a) max(a) min(c) max(c)
21 6 3.5000 1.7078 7 0 1 6 E
grp sum(a) count(a) avg(a) std(a) bit_or(a) bit_and(a) min(a) max(a) min(c) max(c)
NULL 0 0 NULL NULL 0 0 NULL NULL
1 1 1 1.0000 0.0000 1 1 1 1 a a
2 5 2 2.5000 0.5000 3 2 2 3 b c
3 15 3 5.0000 0.8165 7 4 4 6 C E
grp sum
NULL NULL
1 7
2 20
3 44.816496580928
grp a c
NULL NULL
1 2 a
2 5 c
3 9 E
2 3 c
id avg(value1) std(value1)
1 1.000000 0.816497
2 11.000000 0.816497
name avg(value1) std(value1)
Set One 1.000000 0.816497
Set Two 11.000000 0.816497
id avg(rating)
1 3.0000
2 NULL
3 2.0000
count(*)
3
count(*)
1
count(*)
0
count(*)
0
count(a)
1
count(a)
0
count(a)
0
count(b)
2
count(b)
0
count(c)
0
COUNT(i) i COUNT(i)*i
1 1 1
COUNT(i) (i+0) COUNT(i)*(i+0)
1 1 1
sum(num)
147.58
sum(num)
50.15
45.63
51.80
|
