18 lines
463 B
SQL
18 lines
463 B
SQL
--setup
|
|
create table averages (val integer);
|
|
insert into averages values (1);
|
|
insert into averages values (2);
|
|
insert into averages values (3);
|
|
insert into averages values (4);
|
|
insert into averages values (5);
|
|
insert into averages values (6);
|
|
insert into averages values (7);
|
|
insert into averages values (8);
|
|
insert into averages values (9);
|
|
insert into averages values (10);
|
|
-- calculate means
|
|
select
|
|
1/avg(1/val) as harm,
|
|
avg(val) as arith
|
|
from
|
|
averages;
|