oceanbase

1
drop table if exists test;
2
create table test(a int primary key,b int,c int);
3
insert into test values(1,4,null);
4
insert into test values(3,3,null);
5
insert into test values(4,3,null);
6
select avg(distinct(a)),avg(a),avg(b) from test;
7
avg(distinct(a))	avg(a)	avg(b)
8
2.6667	2.6667	3.3333
9
select avg(distinct(b)),avg(b),avg(c) from test;
10
avg(distinct(b))	avg(b)	avg(c)
11
3.5000	3.3333	NULL
12
select avg(c),avg(b),avg(distinct(b)) from test;
13
avg(c)	avg(b)	avg(distinct(b))
14
NULL	3.3333	3.5000
15
select avg(c),avg(b),avg(b) from test;
16
avg(c)	avg(b)	avg(b)
17
NULL	3.3333	3.3333
18