github.com/ncruces/go-sqlite3@v0.15.1-0.20240520133447-53eef1510ff0/ext/stats/TODO.md (about)

     1  # ANSI SQL Aggregate Functions
     2  
     3  https://www.oreilly.com/library/view/sql-in-a/9780596155322/ch04s02.html
     4  
     5  ## Built in aggregates
     6  
     7  - [x] `COUNT(*)`
     8  - [x] `COUNT(expression)`
     9  - [x] `SUM(expression)`
    10  - [x] `AVG(expression)`
    11  - [x] `MIN(expression)`
    12  - [x] `MAX(expression)`
    13  
    14  https://sqlite.org/lang_aggfunc.html
    15  
    16  ## Statistical aggregates
    17  
    18  - [x] `STDDEV_POP(expression)`
    19  - [x] `STDDEV_SAMP(expression)`
    20  - [x] `VAR_POP(expression)`
    21  - [x] `VAR_SAMP(expression)`
    22  - [x] `COVAR_POP(dependent, independent)`
    23  - [x] `COVAR_SAMP(dependent, independent)`
    24  - [x] `CORR(dependent, independent)`
    25  
    26  ## Linear regression aggregates
    27  
    28  - [X] `REGR_AVGX(dependent, independent)`
    29  - [X] `REGR_AVGY(dependent, independent)`
    30  - [X] `REGR_SXX(dependent, independent)`
    31  - [X] `REGR_SYY(dependent, independent)`
    32  - [X] `REGR_SXY(dependent, independent)`
    33  - [X] `REGR_COUNT(dependent, independent)`
    34  - [X] `REGR_SLOPE(dependent, independent)`
    35  - [X] `REGR_INTERCEPT(dependent, independent)`
    36  - [X] `REGR_R2(dependent, independent)`
    37  
    38  ## Set aggregates
    39  
    40  - [X] `CUME_DIST() OVER window`
    41  - [X] `RANK() OVER window`
    42  - [X] `DENSE_RANK() OVER window`
    43  - [X] `PERCENT_RANK() OVER window`
    44  - [ ] `PERCENTILE_CONT(percentile) OVER window`
    45  - [ ] `PERCENTILE_DISC(percentile) OVER window`
    46  
    47  https://sqlite.org/windowfunctions.html#builtins