13 lines
336 B
Plaintext
13 lines
336 B
Plaintext
create or replace function basics(n) as table (
|
|
select n, avg(x), stddev_pop(x), stddev_samp(x)
|
|
from (select random() as x from range(0,n))
|
|
);
|
|
|
|
from basics(100)
|
|
union all from basics(1000)
|
|
union all from basics(10000)
|
|
union all from basics(1000000000);
|
|
|
|
with cte as (select random() as x from range(0,100))
|
|
from histogram(cte, x) ;
|