select avg(qtt) from mydata.sample02;
4.0000
select avg(case when qtt is null then 0 else qtt end) from mydata.sample02;
3.2000
select max(qtt), min(qtt) from mydata.sample02;
10 1
select name, count(name), sum(qtt) from mydata.sample02 group by name having count(name) = 1;
B 1 10
C 1 3
select * from mydata.sample02 order by qtt;
5
1 A 1
2 A 2
4 C 3
3 B 10
