Yes ! Thank you so much. cl sqlite3.c -DSQLITE_ENABLE_MATH_FUNCTIONS -DSQLITE_ENABLE_JSON1 -DSQLITE_ENABLE_FTS4 -DSQLITE_ENABLE_FTS5 -DSQLITE_API=__declspec(dllexport) -link -dll -out:sqlite3.dll and this work on Python-3.10.0a3 / Windows 10 20H2 with datas(criteria, qty) as( values ('a', 1) ,('a', 2) , ('a', 3), ('a', 4) ,('a', 5), ('b',1), ('b',3) ) , intermed(criteria, squared) as (select criteria, power(qty-avg(qty) over (partition by criteria) , 2) from datas ) select criteria, sqrt(sum(squared)/count(*)) as stddev from intermed group by criteria