Update 01_0000_system_numbers.sql
@@ -19,6 +19,6 @@ SELECT argMax(b, a) from (select number + 5 as a, number - 5 as b from numbers_m
select count(distinct number, number + 1 , number + 3 ) from ( select number % 100 as number from numbers(100000));
select count(distinct 3) from numbers(10000);
select uniq(number, number + 1 , number + 3 ) = count(distinct number, number + 1 , number + 3 ) from ( select number % 100 as number from numbers(100000));
- SELECT std(number) from numbers_mt(10000);
- SELECT stddev(number) from numbers_mt(10000);
- SELECT stddev_pop(number) from numbers_mt(10000);
+ SELECT std(number) between 2886.751 and 2886.752 from numbers_mt(10000);
+ SELECT stddev(number) between 2886.751 and 2886.752 from numbers_mt(10000);
+ SELECT stddev_pop(number) between 2886.751 and 2886.752 from numbers_mt(10000);
