module Database.Beam.Query.Extensions
  ( -- * Various combinators corresponding to SQL extensions

    -- ** T614 NTILE function
    ntile_

    -- ** T615 LEAD and LAG function
  , lead1_, lag1_, lead_, lag_
  , leadWithDefault_, lagWithDefault_

    -- ** T616 FIRST_VALUE and LAST_VALUE functions
  ,  firstValue_, lastValue_

    -- ** T618 NTH_VALUE function
  , nthValue_

    -- ** T621 Enhanced numeric functions
  , (**.), ln_, exp_, sqrt_
  , ceiling_, floor_

  , stddevPopOver_, stddevSampOver_
  , varPopOver_, varSampOver_

  , stddevPop_, stddevSamp_
  , varPop_, varSamp_

  , covarPopOver_, covarSampOver_, corrOver_
  , regrSlopeOver_, regrInterceptOver_
  , regrCountOver_, regrRSquaredOver_
  , regrAvgXOver_, regrAvgYOver_
  , regrSXXOver_, regrSYYOver_, regrSXYOver_

  , covarPop_, covarSamp_, corr_, regrSlope_
  , regrIntercept_, regrCount_, regrRSquared_
  , regrAvgX_, regrAvgY_, regrSXX_
  , regrSYY_, regrSXY_
  ) where

import Database.Beam.Query.Internal
import Database.Beam.Query.Aggregate

import Database.Beam.Backend.SQL

ntile_ :: (BeamSqlBackend be, BeamSqlT614Backend be, Integral n)
       => QExpr be s n -> QAgg be s a
ntile_ :: forall be n s a.
(BeamSqlBackend be, BeamSqlT614Backend be, Integral n) =>
QExpr be s n -> QAgg be s a
ntile_ (QExpr TablePrefix
-> Sql92SelectTableExpressionSyntax
     (Sql92SelectSelectTableSyntax
        (Sql92SelectSyntax (BeamSqlBackendSyntax be)))
a) = forall context be s t.
(TablePrefix -> BeamSqlBackendExpressionSyntax be)
-> QGenExpr context be s t
QExpr (forall agg. IsSql2003NtileExpressionSyntax agg => agg -> agg
ntileE forall (f :: * -> *) a b. Functor f => (a -> b) -> f a -> f b
<$> TablePrefix
-> Sql92SelectTableExpressionSyntax
     (Sql92SelectSelectTableSyntax
        (Sql92SelectSyntax (BeamSqlBackendSyntax be)))
a)

lead1_, lag1_
  :: (BeamSqlBackend be, BeamSqlT615Backend be)
  => QExpr be s a -> QAgg be s a
lead1_ :: forall be s a.
(BeamSqlBackend be, BeamSqlT615Backend be) =>
QExpr be s a -> QAgg be s a
lead1_ (QExpr TablePrefix
-> Sql92SelectTableExpressionSyntax
     (Sql92SelectSelectTableSyntax
        (Sql92SelectSyntax (BeamSqlBackendSyntax be)))
a) = forall context be s t.
(TablePrefix -> BeamSqlBackendExpressionSyntax be)
-> QGenExpr context be s t
QExpr (forall agg.
IsSql2003LeadAndLagExpressionSyntax agg =>
agg -> Maybe agg -> Maybe agg -> agg
leadE forall (f :: * -> *) a b. Functor f => (a -> b) -> f a -> f b
<$> TablePrefix
-> Sql92SelectTableExpressionSyntax
     (Sql92SelectSelectTableSyntax
        (Sql92SelectSyntax (BeamSqlBackendSyntax be)))
a forall (f :: * -> *) a b. Applicative f => f (a -> b) -> f a -> f b
<*> forall (f :: * -> *) a. Applicative f => a -> f a
pure forall a. Maybe a
Nothing forall (f :: * -> *) a b. Applicative f => f (a -> b) -> f a -> f b
<*> forall (f :: * -> *) a. Applicative f => a -> f a
pure forall a. Maybe a
Nothing)
lag1_ :: forall be s a.
(BeamSqlBackend be, BeamSqlT615Backend be) =>
QExpr be s a -> QAgg be s a
lag1_ (QExpr TablePrefix
-> Sql92SelectTableExpressionSyntax
     (Sql92SelectSelectTableSyntax
        (Sql92SelectSyntax (BeamSqlBackendSyntax be)))
a) = forall context be s t.
(TablePrefix -> BeamSqlBackendExpressionSyntax be)
-> QGenExpr context be s t
QExpr (forall agg.
IsSql2003LeadAndLagExpressionSyntax agg =>
agg -> Maybe agg -> Maybe agg -> agg
lagE forall (f :: * -> *) a b. Functor f => (a -> b) -> f a -> f b
<$> TablePrefix
-> Sql92SelectTableExpressionSyntax
     (Sql92SelectSelectTableSyntax
        (Sql92SelectSyntax (BeamSqlBackendSyntax be)))
a forall (f :: * -> *) a b. Applicative f => f (a -> b) -> f a -> f b
<*> forall (f :: * -> *) a. Applicative f => a -> f a
pure forall a. Maybe a
Nothing forall (f :: * -> *) a b. Applicative f => f (a -> b) -> f a -> f b
<*> forall (f :: * -> *) a. Applicative f => a -> f a
pure forall a. Maybe a
Nothing)

lead_, lag_
  :: (BeamSqlBackend be, BeamSqlT615Backend be, Integral n)
  => QExpr be s a -> QExpr be s n -> QAgg be s a
lead_ :: forall be n s a.
(BeamSqlBackend be, BeamSqlT615Backend be, Integral n) =>
QExpr be s a -> QExpr be s n -> QAgg be s a
lead_ (QExpr TablePrefix
-> Sql92SelectTableExpressionSyntax
     (Sql92SelectSelectTableSyntax
        (Sql92SelectSyntax (BeamSqlBackendSyntax be)))
a) (QExpr TablePrefix
-> Sql92SelectTableExpressionSyntax
     (Sql92SelectSelectTableSyntax
        (Sql92SelectSyntax (BeamSqlBackendSyntax be)))
n) = forall context be s t.
(TablePrefix -> BeamSqlBackendExpressionSyntax be)
-> QGenExpr context be s t
QExpr (forall agg.
IsSql2003LeadAndLagExpressionSyntax agg =>
agg -> Maybe agg -> Maybe agg -> agg
leadE forall (f :: * -> *) a b. Functor f => (a -> b) -> f a -> f b
<$> TablePrefix
-> Sql92SelectTableExpressionSyntax
     (Sql92SelectSelectTableSyntax
        (Sql92SelectSyntax (BeamSqlBackendSyntax be)))
a forall (f :: * -> *) a b. Applicative f => f (a -> b) -> f a -> f b
<*> (forall a. a -> Maybe a
Just forall (f :: * -> *) a b. Functor f => (a -> b) -> f a -> f b
<$> TablePrefix
-> Sql92SelectTableExpressionSyntax
     (Sql92SelectSelectTableSyntax
        (Sql92SelectSyntax (BeamSqlBackendSyntax be)))
n) forall (f :: * -> *) a b. Applicative f => f (a -> b) -> f a -> f b
<*> forall (f :: * -> *) a. Applicative f => a -> f a
pure forall a. Maybe a
Nothing)
lag_ :: forall be n s a.
(BeamSqlBackend be, BeamSqlT615Backend be, Integral n) =>
QExpr be s a -> QExpr be s n -> QAgg be s a
lag_ (QExpr TablePrefix
-> Sql92SelectTableExpressionSyntax
     (Sql92SelectSelectTableSyntax
        (Sql92SelectSyntax (BeamSqlBackendSyntax be)))
a) (QExpr TablePrefix
-> Sql92SelectTableExpressionSyntax
     (Sql92SelectSelectTableSyntax
        (Sql92SelectSyntax (BeamSqlBackendSyntax be)))
n) = forall context be s t.
(TablePrefix -> BeamSqlBackendExpressionSyntax be)
-> QGenExpr context be s t
QExpr (forall agg.
IsSql2003LeadAndLagExpressionSyntax agg =>
agg -> Maybe agg -> Maybe agg -> agg
lagE forall (f :: * -> *) a b. Functor f => (a -> b) -> f a -> f b
<$> TablePrefix
-> Sql92SelectTableExpressionSyntax
     (Sql92SelectSelectTableSyntax
        (Sql92SelectSyntax (BeamSqlBackendSyntax be)))
a forall (f :: * -> *) a b. Applicative f => f (a -> b) -> f a -> f b
<*> (forall a. a -> Maybe a
Just forall (f :: * -> *) a b. Functor f => (a -> b) -> f a -> f b
<$> TablePrefix
-> Sql92SelectTableExpressionSyntax
     (Sql92SelectSelectTableSyntax
        (Sql92SelectSyntax (BeamSqlBackendSyntax be)))
n) forall (f :: * -> *) a b. Applicative f => f (a -> b) -> f a -> f b
<*> forall (f :: * -> *) a. Applicative f => a -> f a
pure forall a. Maybe a
Nothing)

leadWithDefault_, lagWithDefault_
  :: (BeamSqlBackend be, BeamSqlT615Backend be, Integral n)
  => QExpr be s a -> QExpr be s n -> QExpr be s a
  -> QAgg be s a
leadWithDefault_ :: forall be n s a.
(BeamSqlBackend be, BeamSqlT615Backend be, Integral n) =>
QExpr be s a -> QExpr be s n -> QExpr be s a -> QAgg be s a
leadWithDefault_ (QExpr TablePrefix
-> Sql92SelectTableExpressionSyntax
     (Sql92SelectSelectTableSyntax
        (Sql92SelectSyntax (BeamSqlBackendSyntax be)))
a) (QExpr TablePrefix
-> Sql92SelectTableExpressionSyntax
     (Sql92SelectSelectTableSyntax
        (Sql92SelectSyntax (BeamSqlBackendSyntax be)))
n) (QExpr TablePrefix
-> Sql92SelectTableExpressionSyntax
     (Sql92SelectSelectTableSyntax
        (Sql92SelectSyntax (BeamSqlBackendSyntax be)))
def) =
  forall context be s t.
(TablePrefix -> BeamSqlBackendExpressionSyntax be)
-> QGenExpr context be s t
QExpr (forall agg.
IsSql2003LeadAndLagExpressionSyntax agg =>
agg -> Maybe agg -> Maybe agg -> agg
leadE forall (f :: * -> *) a b. Functor f => (a -> b) -> f a -> f b
<$> TablePrefix
-> Sql92SelectTableExpressionSyntax
     (Sql92SelectSelectTableSyntax
        (Sql92SelectSyntax (BeamSqlBackendSyntax be)))
a forall (f :: * -> *) a b. Applicative f => f (a -> b) -> f a -> f b
<*> forall (f :: * -> *) a b. Functor f => (a -> b) -> f a -> f b
fmap forall a. a -> Maybe a
Just TablePrefix
-> Sql92SelectTableExpressionSyntax
     (Sql92SelectSelectTableSyntax
        (Sql92SelectSyntax (BeamSqlBackendSyntax be)))
n forall (f :: * -> *) a b. Applicative f => f (a -> b) -> f a -> f b
<*> forall (f :: * -> *) a b. Functor f => (a -> b) -> f a -> f b
fmap forall a. a -> Maybe a
Just TablePrefix
-> Sql92SelectTableExpressionSyntax
     (Sql92SelectSelectTableSyntax
        (Sql92SelectSyntax (BeamSqlBackendSyntax be)))
def)
lagWithDefault_ :: forall be n s a.
(BeamSqlBackend be, BeamSqlT615Backend be, Integral n) =>
QExpr be s a -> QExpr be s n -> QExpr be s a -> QAgg be s a
lagWithDefault_ (QExpr TablePrefix
-> Sql92SelectTableExpressionSyntax
     (Sql92SelectSelectTableSyntax
        (Sql92SelectSyntax (BeamSqlBackendSyntax be)))
a) (QExpr TablePrefix
-> Sql92SelectTableExpressionSyntax
     (Sql92SelectSelectTableSyntax
        (Sql92SelectSyntax (BeamSqlBackendSyntax be)))
n) (QExpr TablePrefix
-> Sql92SelectTableExpressionSyntax
     (Sql92SelectSelectTableSyntax
        (Sql92SelectSyntax (BeamSqlBackendSyntax be)))
def) =
  forall context be s t.
(TablePrefix -> BeamSqlBackendExpressionSyntax be)
-> QGenExpr context be s t
QExpr (forall agg.
IsSql2003LeadAndLagExpressionSyntax agg =>
agg -> Maybe agg -> Maybe agg -> agg
lagE forall (f :: * -> *) a b. Functor f => (a -> b) -> f a -> f b
<$> TablePrefix
-> Sql92SelectTableExpressionSyntax
     (Sql92SelectSelectTableSyntax
        (Sql92SelectSyntax (BeamSqlBackendSyntax be)))
a forall (f :: * -> *) a b. Applicative f => f (a -> b) -> f a -> f b
<*> forall (f :: * -> *) a b. Functor f => (a -> b) -> f a -> f b
fmap forall a. a -> Maybe a
Just TablePrefix
-> Sql92SelectTableExpressionSyntax
     (Sql92SelectSelectTableSyntax
        (Sql92SelectSyntax (BeamSqlBackendSyntax be)))
n forall (f :: * -> *) a b. Applicative f => f (a -> b) -> f a -> f b
<*> forall (f :: * -> *) a b. Functor f => (a -> b) -> f a -> f b
fmap forall a. a -> Maybe a
Just TablePrefix
-> Sql92SelectTableExpressionSyntax
     (Sql92SelectSelectTableSyntax
        (Sql92SelectSyntax (BeamSqlBackendSyntax be)))
def)

-- TODO the first 'a' should be nullable, and the second one not
firstValue_, lastValue_
  :: (BeamSqlBackend be, BeamSqlT616Backend be)
  => QExpr be s a -> QAgg be s a
firstValue_ :: forall be s a.
(BeamSqlBackend be, BeamSqlT616Backend be) =>
QExpr be s a -> QAgg be s a
firstValue_ (QExpr TablePrefix
-> Sql92SelectTableExpressionSyntax
     (Sql92SelectSelectTableSyntax
        (Sql92SelectSyntax (BeamSqlBackendSyntax be)))
a) = forall context be s t.
(TablePrefix -> BeamSqlBackendExpressionSyntax be)
-> QGenExpr context be s t
QExpr (forall agg.
IsSql2003FirstValueAndLastValueExpressionSyntax agg =>
agg -> agg
firstValueE forall (f :: * -> *) a b. Functor f => (a -> b) -> f a -> f b
<$> TablePrefix
-> Sql92SelectTableExpressionSyntax
     (Sql92SelectSelectTableSyntax
        (Sql92SelectSyntax (BeamSqlBackendSyntax be)))
a)
lastValue_ :: forall be s a.
(BeamSqlBackend be, BeamSqlT616Backend be) =>
QExpr be s a -> QAgg be s a
lastValue_ (QExpr TablePrefix
-> Sql92SelectTableExpressionSyntax
     (Sql92SelectSelectTableSyntax
        (Sql92SelectSyntax (BeamSqlBackendSyntax be)))
a) = forall context be s t.
(TablePrefix -> BeamSqlBackendExpressionSyntax be)
-> QGenExpr context be s t
QExpr (forall agg.
IsSql2003FirstValueAndLastValueExpressionSyntax agg =>
agg -> agg
lastValueE forall (f :: * -> *) a b. Functor f => (a -> b) -> f a -> f b
<$> TablePrefix
-> Sql92SelectTableExpressionSyntax
     (Sql92SelectSelectTableSyntax
        (Sql92SelectSyntax (BeamSqlBackendSyntax be)))
a)

-- TODO see comment for 'firstValue_' and 'lastValue_'
nthValue_
  :: (BeamSqlBackend be, BeamSqlT618Backend be, Integral n)
  => QExpr be s a -> QExpr be s n -> QAgg be s a
nthValue_ :: forall be n s a.
(BeamSqlBackend be, BeamSqlT618Backend be, Integral n) =>
QExpr be s a -> QExpr be s n -> QAgg be s a
nthValue_ (QExpr TablePrefix
-> Sql92SelectTableExpressionSyntax
     (Sql92SelectSelectTableSyntax
        (Sql92SelectSyntax (BeamSqlBackendSyntax be)))
a) (QExpr TablePrefix
-> Sql92SelectTableExpressionSyntax
     (Sql92SelectSelectTableSyntax
        (Sql92SelectSyntax (BeamSqlBackendSyntax be)))
n) = forall context be s t.
(TablePrefix -> BeamSqlBackendExpressionSyntax be)
-> QGenExpr context be s t
QExpr (forall agg.
IsSql2003NthValueExpressionSyntax agg =>
agg -> agg -> agg
nthValueE forall (f :: * -> *) a b. Functor f => (a -> b) -> f a -> f b
<$> TablePrefix
-> Sql92SelectTableExpressionSyntax
     (Sql92SelectSelectTableSyntax
        (Sql92SelectSyntax (BeamSqlBackendSyntax be)))
a forall (f :: * -> *) a b. Applicative f => f (a -> b) -> f a -> f b
<*> TablePrefix
-> Sql92SelectTableExpressionSyntax
     (Sql92SelectSelectTableSyntax
        (Sql92SelectSyntax (BeamSqlBackendSyntax be)))
n)

ln_, exp_, sqrt_
  :: (Floating a, BeamSqlBackend be, BeamSqlT621Backend be)
  => QGenExpr ctxt be s a -> QGenExpr ctxt be s a
ln_ :: forall a be ctxt s.
(Floating a, BeamSqlBackend be, BeamSqlT621Backend be) =>
QGenExpr ctxt be s a -> QGenExpr ctxt be s a
ln_ (QExpr TablePrefix
-> Sql92SelectTableExpressionSyntax
     (Sql92SelectSelectTableSyntax
        (Sql92SelectSyntax (BeamSqlBackendSyntax be)))
a) = forall context be s t.
(TablePrefix -> BeamSqlBackendExpressionSyntax be)
-> QGenExpr context be s t
QExpr (forall expr.
IsSql2003EnhancedNumericFunctionsExpressionSyntax expr =>
expr -> expr
lnE forall (f :: * -> *) a b. Functor f => (a -> b) -> f a -> f b
<$> TablePrefix
-> Sql92SelectTableExpressionSyntax
     (Sql92SelectSelectTableSyntax
        (Sql92SelectSyntax (BeamSqlBackendSyntax be)))
a)
exp_ :: forall a be ctxt s.
(Floating a, BeamSqlBackend be, BeamSqlT621Backend be) =>
QGenExpr ctxt be s a -> QGenExpr ctxt be s a
exp_ (QExpr TablePrefix
-> Sql92SelectTableExpressionSyntax
     (Sql92SelectSelectTableSyntax
        (Sql92SelectSyntax (BeamSqlBackendSyntax be)))
a) = forall context be s t.
(TablePrefix -> BeamSqlBackendExpressionSyntax be)
-> QGenExpr context be s t
QExpr (forall expr.
IsSql2003EnhancedNumericFunctionsExpressionSyntax expr =>
expr -> expr
expE forall (f :: * -> *) a b. Functor f => (a -> b) -> f a -> f b
<$> TablePrefix
-> Sql92SelectTableExpressionSyntax
     (Sql92SelectSelectTableSyntax
        (Sql92SelectSyntax (BeamSqlBackendSyntax be)))
a)
sqrt_ :: forall a be ctxt s.
(Floating a, BeamSqlBackend be, BeamSqlT621Backend be) =>
QGenExpr ctxt be s a -> QGenExpr ctxt be s a
sqrt_ (QExpr TablePrefix
-> Sql92SelectTableExpressionSyntax
     (Sql92SelectSelectTableSyntax
        (Sql92SelectSyntax (BeamSqlBackendSyntax be)))
a) = forall context be s t.
(TablePrefix -> BeamSqlBackendExpressionSyntax be)
-> QGenExpr context be s t
QExpr (forall expr.
IsSql2003EnhancedNumericFunctionsExpressionSyntax expr =>
expr -> expr
sqrtE forall (f :: * -> *) a b. Functor f => (a -> b) -> f a -> f b
<$> TablePrefix
-> Sql92SelectTableExpressionSyntax
     (Sql92SelectSelectTableSyntax
        (Sql92SelectSyntax (BeamSqlBackendSyntax be)))
a)

ceiling_, floor_
  :: (RealFrac a, Integral b, BeamSqlBackend be, BeamSqlT621Backend be)
  => QGenExpr ctxt be s a -> QGenExpr ctxt be s b
ceiling_ :: forall a b be ctxt s.
(RealFrac a, Integral b, BeamSqlBackend be,
 BeamSqlT621Backend be) =>
QGenExpr ctxt be s a -> QGenExpr ctxt be s b
ceiling_ (QExpr TablePrefix
-> Sql92SelectTableExpressionSyntax
     (Sql92SelectSelectTableSyntax
        (Sql92SelectSyntax (BeamSqlBackendSyntax be)))
a) = forall context be s t.
(TablePrefix -> BeamSqlBackendExpressionSyntax be)
-> QGenExpr context be s t
QExpr (forall expr.
IsSql2003EnhancedNumericFunctionsExpressionSyntax expr =>
expr -> expr
ceilE forall (f :: * -> *) a b. Functor f => (a -> b) -> f a -> f b
<$> TablePrefix
-> Sql92SelectTableExpressionSyntax
     (Sql92SelectSelectTableSyntax
        (Sql92SelectSyntax (BeamSqlBackendSyntax be)))
a)
floor_ :: forall a b be ctxt s.
(RealFrac a, Integral b, BeamSqlBackend be,
 BeamSqlT621Backend be) =>
QGenExpr ctxt be s a -> QGenExpr ctxt be s b
floor_ (QExpr TablePrefix
-> Sql92SelectTableExpressionSyntax
     (Sql92SelectSelectTableSyntax
        (Sql92SelectSyntax (BeamSqlBackendSyntax be)))
a) = forall context be s t.
(TablePrefix -> BeamSqlBackendExpressionSyntax be)
-> QGenExpr context be s t
QExpr (forall expr.
IsSql2003EnhancedNumericFunctionsExpressionSyntax expr =>
expr -> expr
floorE forall (f :: * -> *) a b. Functor f => (a -> b) -> f a -> f b
<$> TablePrefix
-> Sql92SelectTableExpressionSyntax
     (Sql92SelectSelectTableSyntax
        (Sql92SelectSyntax (BeamSqlBackendSyntax be)))
a)

infixr 8 **.
(**.) :: (Floating a, BeamSqlBackend be, BeamSqlT621Backend be)
      => QGenExpr ctxt be s a -> QGenExpr ctxt be s a -> QGenExpr ctxt be s a
QExpr TablePrefix
-> Sql92SelectTableExpressionSyntax
     (Sql92SelectSelectTableSyntax
        (Sql92SelectSyntax (BeamSqlBackendSyntax be)))
a **. :: forall a be ctxt s.
(Floating a, BeamSqlBackend be, BeamSqlT621Backend be) =>
QGenExpr ctxt be s a
-> QGenExpr ctxt be s a -> QGenExpr ctxt be s a
**. QExpr TablePrefix
-> Sql92SelectTableExpressionSyntax
     (Sql92SelectSelectTableSyntax
        (Sql92SelectSyntax (BeamSqlBackendSyntax be)))
b = forall context be s t.
(TablePrefix -> BeamSqlBackendExpressionSyntax be)
-> QGenExpr context be s t
QExpr (forall expr.
IsSql2003EnhancedNumericFunctionsExpressionSyntax expr =>
expr -> expr -> expr
powerE forall (f :: * -> *) a b. Functor f => (a -> b) -> f a -> f b
<$> TablePrefix
-> Sql92SelectTableExpressionSyntax
     (Sql92SelectSelectTableSyntax
        (Sql92SelectSyntax (BeamSqlBackendSyntax be)))
a forall (f :: * -> *) a b. Applicative f => f (a -> b) -> f a -> f b
<*> TablePrefix
-> Sql92SelectTableExpressionSyntax
     (Sql92SelectSelectTableSyntax
        (Sql92SelectSyntax (BeamSqlBackendSyntax be)))
b)

stddevPopOver_, stddevSampOver_, varPopOver_, varSampOver_
  :: (Num a, Floating b, BeamSqlBackend be, BeamSqlT621Backend be)
  => Maybe (BeamSqlBackendAggregationQuantifierSyntax be) -> QExpr be s a
  -> QAgg be s b
stddevPopOver_ :: forall a b be s.
(Num a, Floating b, BeamSqlBackend be, BeamSqlT621Backend be) =>
Maybe (BeamSqlBackendAggregationQuantifierSyntax be)
-> QExpr be s a -> QAgg be s b
stddevPopOver_ Maybe (BeamSqlBackendAggregationQuantifierSyntax be)
q (QExpr TablePrefix
-> Sql92SelectTableExpressionSyntax
     (Sql92SelectSelectTableSyntax
        (Sql92SelectSyntax (BeamSqlBackendSyntax be)))
x) = forall context be s t.
(TablePrefix -> BeamSqlBackendExpressionSyntax be)
-> QGenExpr context be s t
QExpr (forall agg.
IsSql2003EnhancedNumericFunctionsAggregationExpressionSyntax agg =>
Maybe (Sql92AggregationSetQuantifierSyntax agg) -> agg -> agg
stddevPopE Maybe (BeamSqlBackendAggregationQuantifierSyntax be)
q forall (f :: * -> *) a b. Functor f => (a -> b) -> f a -> f b
<$> TablePrefix
-> Sql92SelectTableExpressionSyntax
     (Sql92SelectSelectTableSyntax
        (Sql92SelectSyntax (BeamSqlBackendSyntax be)))
x)
stddevSampOver_ :: forall a b be s.
(Num a, Floating b, BeamSqlBackend be, BeamSqlT621Backend be) =>
Maybe (BeamSqlBackendAggregationQuantifierSyntax be)
-> QExpr be s a -> QAgg be s b
stddevSampOver_ Maybe (BeamSqlBackendAggregationQuantifierSyntax be)
q (QExpr TablePrefix
-> Sql92SelectTableExpressionSyntax
     (Sql92SelectSelectTableSyntax
        (Sql92SelectSyntax (BeamSqlBackendSyntax be)))
x) = forall context be s t.
(TablePrefix -> BeamSqlBackendExpressionSyntax be)
-> QGenExpr context be s t
QExpr (forall agg.
IsSql2003EnhancedNumericFunctionsAggregationExpressionSyntax agg =>
Maybe (Sql92AggregationSetQuantifierSyntax agg) -> agg -> agg
stddevSampE Maybe (BeamSqlBackendAggregationQuantifierSyntax be)
q forall (f :: * -> *) a b. Functor f => (a -> b) -> f a -> f b
<$> TablePrefix
-> Sql92SelectTableExpressionSyntax
     (Sql92SelectSelectTableSyntax
        (Sql92SelectSyntax (BeamSqlBackendSyntax be)))
x)
varPopOver_ :: forall a b be s.
(Num a, Floating b, BeamSqlBackend be, BeamSqlT621Backend be) =>
Maybe (BeamSqlBackendAggregationQuantifierSyntax be)
-> QExpr be s a -> QAgg be s b
varPopOver_ Maybe (BeamSqlBackendAggregationQuantifierSyntax be)
q (QExpr TablePrefix
-> Sql92SelectTableExpressionSyntax
     (Sql92SelectSelectTableSyntax
        (Sql92SelectSyntax (BeamSqlBackendSyntax be)))
x) = forall context be s t.
(TablePrefix -> BeamSqlBackendExpressionSyntax be)
-> QGenExpr context be s t
QExpr (forall agg.
IsSql2003EnhancedNumericFunctionsAggregationExpressionSyntax agg =>
Maybe (Sql92AggregationSetQuantifierSyntax agg) -> agg -> agg
varPopE Maybe (BeamSqlBackendAggregationQuantifierSyntax be)
q forall (f :: * -> *) a b. Functor f => (a -> b) -> f a -> f b
<$> TablePrefix
-> Sql92SelectTableExpressionSyntax
     (Sql92SelectSelectTableSyntax
        (Sql92SelectSyntax (BeamSqlBackendSyntax be)))
x)
varSampOver_ :: forall a b be s.
(Num a, Floating b, BeamSqlBackend be, BeamSqlT621Backend be) =>
Maybe (BeamSqlBackendAggregationQuantifierSyntax be)
-> QExpr be s a -> QAgg be s b
varSampOver_ Maybe (BeamSqlBackendAggregationQuantifierSyntax be)
q (QExpr TablePrefix
-> Sql92SelectTableExpressionSyntax
     (Sql92SelectSelectTableSyntax
        (Sql92SelectSyntax (BeamSqlBackendSyntax be)))
x) = forall context be s t.
(TablePrefix -> BeamSqlBackendExpressionSyntax be)
-> QGenExpr context be s t
QExpr (forall agg.
IsSql2003EnhancedNumericFunctionsAggregationExpressionSyntax agg =>
Maybe (Sql92AggregationSetQuantifierSyntax agg) -> agg -> agg
varSampE Maybe (BeamSqlBackendAggregationQuantifierSyntax be)
q forall (f :: * -> *) a b. Functor f => (a -> b) -> f a -> f b
<$> TablePrefix
-> Sql92SelectTableExpressionSyntax
     (Sql92SelectSelectTableSyntax
        (Sql92SelectSyntax (BeamSqlBackendSyntax be)))
x)

stddevPop_, stddevSamp_, varPop_, varSamp_
  :: (Num a, Floating b, BeamSqlBackend be, BeamSqlT621Backend be)
  => QExpr be s a -> QAgg be s b
stddevPop_ :: forall a b be s.
(Num a, Floating b, BeamSqlBackend be, BeamSqlT621Backend be) =>
QExpr be s a -> QAgg be s b
stddevPop_ = forall a b be s.
(Num a, Floating b, BeamSqlBackend be, BeamSqlT621Backend be) =>
Maybe (BeamSqlBackendAggregationQuantifierSyntax be)
-> QExpr be s a -> QAgg be s b
stddevPopOver_ forall s. IsSql92AggregationSetQuantifierSyntax s => Maybe s
allInGroup_
stddevSamp_ :: forall a b be s.
(Num a, Floating b, BeamSqlBackend be, BeamSqlT621Backend be) =>
QExpr be s a -> QAgg be s b
stddevSamp_ = forall a b be s.
(Num a, Floating b, BeamSqlBackend be, BeamSqlT621Backend be) =>
Maybe (BeamSqlBackendAggregationQuantifierSyntax be)
-> QExpr be s a -> QAgg be s b
stddevSampOver_ forall s. IsSql92AggregationSetQuantifierSyntax s => Maybe s
allInGroup_
varPop_ :: forall a b be s.
(Num a, Floating b, BeamSqlBackend be, BeamSqlT621Backend be) =>
QExpr be s a -> QAgg be s b
varPop_ = forall a b be s.
(Num a, Floating b, BeamSqlBackend be, BeamSqlT621Backend be) =>
Maybe (BeamSqlBackendAggregationQuantifierSyntax be)
-> QExpr be s a -> QAgg be s b
varPopOver_ forall s. IsSql92AggregationSetQuantifierSyntax s => Maybe s
allInGroup_
varSamp_ :: forall a b be s.
(Num a, Floating b, BeamSqlBackend be, BeamSqlT621Backend be) =>
QExpr be s a -> QAgg be s b
varSamp_ = forall a b be s.
(Num a, Floating b, BeamSqlBackend be, BeamSqlT621Backend be) =>
Maybe (BeamSqlBackendAggregationQuantifierSyntax be)
-> QExpr be s a -> QAgg be s b
varSampOver_ forall s. IsSql92AggregationSetQuantifierSyntax s => Maybe s
allInGroup_

covarPopOver_, covarSampOver_, corrOver_, regrSlopeOver_, regrInterceptOver_,
  regrCountOver_, regrRSquaredOver_, regrAvgYOver_, regrAvgXOver_,
  regrSXXOver_, regrSXYOver_, regrSYYOver_
  :: (Num a, Floating b, BeamSqlBackend be, BeamSqlT621Backend be)
  => Maybe (BeamSqlBackendAggregationQuantifierSyntax be) -> QExpr be s a -> QExpr be s a
  -> QExpr be s b
covarPopOver_ :: forall a b be s.
(Num a, Floating b, BeamSqlBackend be, BeamSqlT621Backend be) =>
Maybe (BeamSqlBackendAggregationQuantifierSyntax be)
-> QExpr be s a -> QExpr be s a -> QExpr be s b
covarPopOver_ Maybe (BeamSqlBackendAggregationQuantifierSyntax be)
q (QExpr TablePrefix
-> Sql92SelectTableExpressionSyntax
     (Sql92SelectSelectTableSyntax
        (Sql92SelectSyntax (BeamSqlBackendSyntax be)))
x) (QExpr TablePrefix
-> Sql92SelectTableExpressionSyntax
     (Sql92SelectSelectTableSyntax
        (Sql92SelectSyntax (BeamSqlBackendSyntax be)))
y) = forall context be s t.
(TablePrefix -> BeamSqlBackendExpressionSyntax be)
-> QGenExpr context be s t
QExpr (forall agg.
IsSql2003EnhancedNumericFunctionsAggregationExpressionSyntax agg =>
Maybe (Sql92AggregationSetQuantifierSyntax agg)
-> agg -> agg -> agg
covarPopE Maybe (BeamSqlBackendAggregationQuantifierSyntax be)
q forall (f :: * -> *) a b. Functor f => (a -> b) -> f a -> f b
<$> TablePrefix
-> Sql92SelectTableExpressionSyntax
     (Sql92SelectSelectTableSyntax
        (Sql92SelectSyntax (BeamSqlBackendSyntax be)))
x forall (f :: * -> *) a b. Applicative f => f (a -> b) -> f a -> f b
<*> TablePrefix
-> Sql92SelectTableExpressionSyntax
     (Sql92SelectSelectTableSyntax
        (Sql92SelectSyntax (BeamSqlBackendSyntax be)))
y)
covarSampOver_ :: forall a b be s.
(Num a, Floating b, BeamSqlBackend be, BeamSqlT621Backend be) =>
Maybe (BeamSqlBackendAggregationQuantifierSyntax be)
-> QExpr be s a -> QExpr be s a -> QExpr be s b
covarSampOver_ Maybe (BeamSqlBackendAggregationQuantifierSyntax be)
q (QExpr TablePrefix
-> Sql92SelectTableExpressionSyntax
     (Sql92SelectSelectTableSyntax
        (Sql92SelectSyntax (BeamSqlBackendSyntax be)))
x) (QExpr TablePrefix
-> Sql92SelectTableExpressionSyntax
     (Sql92SelectSelectTableSyntax
        (Sql92SelectSyntax (BeamSqlBackendSyntax be)))
y) = forall context be s t.
(TablePrefix -> BeamSqlBackendExpressionSyntax be)
-> QGenExpr context be s t
QExpr (forall agg.
IsSql2003EnhancedNumericFunctionsAggregationExpressionSyntax agg =>
Maybe (Sql92AggregationSetQuantifierSyntax agg)
-> agg -> agg -> agg
covarSampE Maybe (BeamSqlBackendAggregationQuantifierSyntax be)
q forall (f :: * -> *) a b. Functor f => (a -> b) -> f a -> f b
<$> TablePrefix
-> Sql92SelectTableExpressionSyntax
     (Sql92SelectSelectTableSyntax
        (Sql92SelectSyntax (BeamSqlBackendSyntax be)))
x forall (f :: * -> *) a b. Applicative f => f (a -> b) -> f a -> f b
<*> TablePrefix
-> Sql92SelectTableExpressionSyntax
     (Sql92SelectSelectTableSyntax
        (Sql92SelectSyntax (BeamSqlBackendSyntax be)))
y)
corrOver_ :: forall a b be s.
(Num a, Floating b, BeamSqlBackend be, BeamSqlT621Backend be) =>
Maybe (BeamSqlBackendAggregationQuantifierSyntax be)
-> QExpr be s a -> QExpr be s a -> QExpr be s b
corrOver_ Maybe (BeamSqlBackendAggregationQuantifierSyntax be)
q (QExpr TablePrefix
-> Sql92SelectTableExpressionSyntax
     (Sql92SelectSelectTableSyntax
        (Sql92SelectSyntax (BeamSqlBackendSyntax be)))
x) (QExpr TablePrefix
-> Sql92SelectTableExpressionSyntax
     (Sql92SelectSelectTableSyntax
        (Sql92SelectSyntax (BeamSqlBackendSyntax be)))
y) = forall context be s t.
(TablePrefix -> BeamSqlBackendExpressionSyntax be)
-> QGenExpr context be s t
QExpr (forall agg.
IsSql2003EnhancedNumericFunctionsAggregationExpressionSyntax agg =>
Maybe (Sql92AggregationSetQuantifierSyntax agg)
-> agg -> agg -> agg
corrE Maybe (BeamSqlBackendAggregationQuantifierSyntax be)
q forall (f :: * -> *) a b. Functor f => (a -> b) -> f a -> f b
<$> TablePrefix
-> Sql92SelectTableExpressionSyntax
     (Sql92SelectSelectTableSyntax
        (Sql92SelectSyntax (BeamSqlBackendSyntax be)))
x forall (f :: * -> *) a b. Applicative f => f (a -> b) -> f a -> f b
<*> TablePrefix
-> Sql92SelectTableExpressionSyntax
     (Sql92SelectSelectTableSyntax
        (Sql92SelectSyntax (BeamSqlBackendSyntax be)))
y)
regrSlopeOver_ :: forall a b be s.
(Num a, Floating b, BeamSqlBackend be, BeamSqlT621Backend be) =>
Maybe (BeamSqlBackendAggregationQuantifierSyntax be)
-> QExpr be s a -> QExpr be s a -> QExpr be s b
regrSlopeOver_ Maybe (BeamSqlBackendAggregationQuantifierSyntax be)
q (QExpr TablePrefix
-> Sql92SelectTableExpressionSyntax
     (Sql92SelectSelectTableSyntax
        (Sql92SelectSyntax (BeamSqlBackendSyntax be)))
x) (QExpr TablePrefix
-> Sql92SelectTableExpressionSyntax
     (Sql92SelectSelectTableSyntax
        (Sql92SelectSyntax (BeamSqlBackendSyntax be)))
y) = forall context be s t.
(TablePrefix -> BeamSqlBackendExpressionSyntax be)
-> QGenExpr context be s t
QExpr (forall agg.
IsSql2003EnhancedNumericFunctionsAggregationExpressionSyntax agg =>
Maybe (Sql92AggregationSetQuantifierSyntax agg)
-> agg -> agg -> agg
regrSlopeE Maybe (BeamSqlBackendAggregationQuantifierSyntax be)
q forall (f :: * -> *) a b. Functor f => (a -> b) -> f a -> f b
<$> TablePrefix
-> Sql92SelectTableExpressionSyntax
     (Sql92SelectSelectTableSyntax
        (Sql92SelectSyntax (BeamSqlBackendSyntax be)))
x forall (f :: * -> *) a b. Applicative f => f (a -> b) -> f a -> f b
<*> TablePrefix
-> Sql92SelectTableExpressionSyntax
     (Sql92SelectSelectTableSyntax
        (Sql92SelectSyntax (BeamSqlBackendSyntax be)))
y)
regrInterceptOver_ :: forall a b be s.
(Num a, Floating b, BeamSqlBackend be, BeamSqlT621Backend be) =>
Maybe (BeamSqlBackendAggregationQuantifierSyntax be)
-> QExpr be s a -> QExpr be s a -> QExpr be s b
regrInterceptOver_ Maybe (BeamSqlBackendAggregationQuantifierSyntax be)
q (QExpr TablePrefix
-> Sql92SelectTableExpressionSyntax
     (Sql92SelectSelectTableSyntax
        (Sql92SelectSyntax (BeamSqlBackendSyntax be)))
x) (QExpr TablePrefix
-> Sql92SelectTableExpressionSyntax
     (Sql92SelectSelectTableSyntax
        (Sql92SelectSyntax (BeamSqlBackendSyntax be)))
y) = forall context be s t.
(TablePrefix -> BeamSqlBackendExpressionSyntax be)
-> QGenExpr context be s t
QExpr (forall agg.
IsSql2003EnhancedNumericFunctionsAggregationExpressionSyntax agg =>
Maybe (Sql92AggregationSetQuantifierSyntax agg)
-> agg -> agg -> agg
regrInterceptE Maybe (BeamSqlBackendAggregationQuantifierSyntax be)
q forall (f :: * -> *) a b. Functor f => (a -> b) -> f a -> f b
<$> TablePrefix
-> Sql92SelectTableExpressionSyntax
     (Sql92SelectSelectTableSyntax
        (Sql92SelectSyntax (BeamSqlBackendSyntax be)))
x forall (f :: * -> *) a b. Applicative f => f (a -> b) -> f a -> f b
<*> TablePrefix
-> Sql92SelectTableExpressionSyntax
     (Sql92SelectSelectTableSyntax
        (Sql92SelectSyntax (BeamSqlBackendSyntax be)))
y)
regrCountOver_ :: forall a b be s.
(Num a, Floating b, BeamSqlBackend be, BeamSqlT621Backend be) =>
Maybe (BeamSqlBackendAggregationQuantifierSyntax be)
-> QExpr be s a -> QExpr be s a -> QExpr be s b
regrCountOver_ Maybe (BeamSqlBackendAggregationQuantifierSyntax be)
q (QExpr TablePrefix
-> Sql92SelectTableExpressionSyntax
     (Sql92SelectSelectTableSyntax
        (Sql92SelectSyntax (BeamSqlBackendSyntax be)))
x) (QExpr TablePrefix
-> Sql92SelectTableExpressionSyntax
     (Sql92SelectSelectTableSyntax
        (Sql92SelectSyntax (BeamSqlBackendSyntax be)))
y) = forall context be s t.
(TablePrefix -> BeamSqlBackendExpressionSyntax be)
-> QGenExpr context be s t
QExpr (forall agg.
IsSql2003EnhancedNumericFunctionsAggregationExpressionSyntax agg =>
Maybe (Sql92AggregationSetQuantifierSyntax agg)
-> agg -> agg -> agg
regrCountE Maybe (BeamSqlBackendAggregationQuantifierSyntax be)
q forall (f :: * -> *) a b. Functor f => (a -> b) -> f a -> f b
<$> TablePrefix
-> Sql92SelectTableExpressionSyntax
     (Sql92SelectSelectTableSyntax
        (Sql92SelectSyntax (BeamSqlBackendSyntax be)))
x forall (f :: * -> *) a b. Applicative f => f (a -> b) -> f a -> f b
<*> TablePrefix
-> Sql92SelectTableExpressionSyntax
     (Sql92SelectSelectTableSyntax
        (Sql92SelectSyntax (BeamSqlBackendSyntax be)))
y)
regrRSquaredOver_ :: forall a b be s.
(Num a, Floating b, BeamSqlBackend be, BeamSqlT621Backend be) =>
Maybe (BeamSqlBackendAggregationQuantifierSyntax be)
-> QExpr be s a -> QExpr be s a -> QExpr be s b
regrRSquaredOver_ Maybe (BeamSqlBackendAggregationQuantifierSyntax be)
q (QExpr TablePrefix
-> Sql92SelectTableExpressionSyntax
     (Sql92SelectSelectTableSyntax
        (Sql92SelectSyntax (BeamSqlBackendSyntax be)))
x) (QExpr TablePrefix
-> Sql92SelectTableExpressionSyntax
     (Sql92SelectSelectTableSyntax
        (Sql92SelectSyntax (BeamSqlBackendSyntax be)))
y) = forall context be s t.
(TablePrefix -> BeamSqlBackendExpressionSyntax be)
-> QGenExpr context be s t
QExpr (forall agg.
IsSql2003EnhancedNumericFunctionsAggregationExpressionSyntax agg =>
Maybe (Sql92AggregationSetQuantifierSyntax agg)
-> agg -> agg -> agg
regrRSquaredE Maybe (BeamSqlBackendAggregationQuantifierSyntax be)
q forall (f :: * -> *) a b. Functor f => (a -> b) -> f a -> f b
<$> TablePrefix
-> Sql92SelectTableExpressionSyntax
     (Sql92SelectSelectTableSyntax
        (Sql92SelectSyntax (BeamSqlBackendSyntax be)))
x forall (f :: * -> *) a b. Applicative f => f (a -> b) -> f a -> f b
<*> TablePrefix
-> Sql92SelectTableExpressionSyntax
     (Sql92SelectSelectTableSyntax
        (Sql92SelectSyntax (BeamSqlBackendSyntax be)))
y)
regrAvgYOver_ :: forall a b be s.
(Num a, Floating b, BeamSqlBackend be, BeamSqlT621Backend be) =>
Maybe (BeamSqlBackendAggregationQuantifierSyntax be)
-> QExpr be s a -> QExpr be s a -> QExpr be s b
regrAvgYOver_ Maybe (BeamSqlBackendAggregationQuantifierSyntax be)
q (QExpr TablePrefix
-> Sql92SelectTableExpressionSyntax
     (Sql92SelectSelectTableSyntax
        (Sql92SelectSyntax (BeamSqlBackendSyntax be)))
x) (QExpr TablePrefix
-> Sql92SelectTableExpressionSyntax
     (Sql92SelectSelectTableSyntax
        (Sql92SelectSyntax (BeamSqlBackendSyntax be)))
y) = forall context be s t.
(TablePrefix -> BeamSqlBackendExpressionSyntax be)
-> QGenExpr context be s t
QExpr (forall agg.
IsSql2003EnhancedNumericFunctionsAggregationExpressionSyntax agg =>
Maybe (Sql92AggregationSetQuantifierSyntax agg)
-> agg -> agg -> agg
regrAvgYE Maybe (BeamSqlBackendAggregationQuantifierSyntax be)
q forall (f :: * -> *) a b. Functor f => (a -> b) -> f a -> f b
<$> TablePrefix
-> Sql92SelectTableExpressionSyntax
     (Sql92SelectSelectTableSyntax
        (Sql92SelectSyntax (BeamSqlBackendSyntax be)))
x forall (f :: * -> *) a b. Applicative f => f (a -> b) -> f a -> f b
<*> TablePrefix
-> Sql92SelectTableExpressionSyntax
     (Sql92SelectSelectTableSyntax
        (Sql92SelectSyntax (BeamSqlBackendSyntax be)))
y)
regrAvgXOver_ :: forall a b be s.
(Num a, Floating b, BeamSqlBackend be, BeamSqlT621Backend be) =>
Maybe (BeamSqlBackendAggregationQuantifierSyntax be)
-> QExpr be s a -> QExpr be s a -> QExpr be s b
regrAvgXOver_ Maybe (BeamSqlBackendAggregationQuantifierSyntax be)
q (QExpr TablePrefix
-> Sql92SelectTableExpressionSyntax
     (Sql92SelectSelectTableSyntax
        (Sql92SelectSyntax (BeamSqlBackendSyntax be)))
x) (QExpr TablePrefix
-> Sql92SelectTableExpressionSyntax
     (Sql92SelectSelectTableSyntax
        (Sql92SelectSyntax (BeamSqlBackendSyntax be)))
y) = forall context be s t.
(TablePrefix -> BeamSqlBackendExpressionSyntax be)
-> QGenExpr context be s t
QExpr (forall agg.
IsSql2003EnhancedNumericFunctionsAggregationExpressionSyntax agg =>
Maybe (Sql92AggregationSetQuantifierSyntax agg)
-> agg -> agg -> agg
regrAvgXE Maybe (BeamSqlBackendAggregationQuantifierSyntax be)
q forall (f :: * -> *) a b. Functor f => (a -> b) -> f a -> f b
<$> TablePrefix
-> Sql92SelectTableExpressionSyntax
     (Sql92SelectSelectTableSyntax
        (Sql92SelectSyntax (BeamSqlBackendSyntax be)))
x forall (f :: * -> *) a b. Applicative f => f (a -> b) -> f a -> f b
<*> TablePrefix
-> Sql92SelectTableExpressionSyntax
     (Sql92SelectSelectTableSyntax
        (Sql92SelectSyntax (BeamSqlBackendSyntax be)))
y)
regrSXXOver_ :: forall a b be s.
(Num a, Floating b, BeamSqlBackend be, BeamSqlT621Backend be) =>
Maybe (BeamSqlBackendAggregationQuantifierSyntax be)
-> QExpr be s a -> QExpr be s a -> QExpr be s b
regrSXXOver_ Maybe (BeamSqlBackendAggregationQuantifierSyntax be)
q (QExpr TablePrefix
-> Sql92SelectTableExpressionSyntax
     (Sql92SelectSelectTableSyntax
        (Sql92SelectSyntax (BeamSqlBackendSyntax be)))
x) (QExpr TablePrefix
-> Sql92SelectTableExpressionSyntax
     (Sql92SelectSelectTableSyntax
        (Sql92SelectSyntax (BeamSqlBackendSyntax be)))
y) = forall context be s t.
(TablePrefix -> BeamSqlBackendExpressionSyntax be)
-> QGenExpr context be s t
QExpr (forall agg.
IsSql2003EnhancedNumericFunctionsAggregationExpressionSyntax agg =>
Maybe (Sql92AggregationSetQuantifierSyntax agg)
-> agg -> agg -> agg
regrSXXE Maybe (BeamSqlBackendAggregationQuantifierSyntax be)
q forall (f :: * -> *) a b. Functor f => (a -> b) -> f a -> f b
<$> TablePrefix
-> Sql92SelectTableExpressionSyntax
     (Sql92SelectSelectTableSyntax
        (Sql92SelectSyntax (BeamSqlBackendSyntax be)))
x forall (f :: * -> *) a b. Applicative f => f (a -> b) -> f a -> f b
<*> TablePrefix
-> Sql92SelectTableExpressionSyntax
     (Sql92SelectSelectTableSyntax
        (Sql92SelectSyntax (BeamSqlBackendSyntax be)))
y)
regrSYYOver_ :: forall a b be s.
(Num a, Floating b, BeamSqlBackend be, BeamSqlT621Backend be) =>
Maybe (BeamSqlBackendAggregationQuantifierSyntax be)
-> QExpr be s a -> QExpr be s a -> QExpr be s b
regrSYYOver_ Maybe (BeamSqlBackendAggregationQuantifierSyntax be)
q (QExpr TablePrefix
-> Sql92SelectTableExpressionSyntax
     (Sql92SelectSelectTableSyntax
        (Sql92SelectSyntax (BeamSqlBackendSyntax be)))
x) (QExpr TablePrefix
-> Sql92SelectTableExpressionSyntax
     (Sql92SelectSelectTableSyntax
        (Sql92SelectSyntax (BeamSqlBackendSyntax be)))
y) = forall context be s t.
(TablePrefix -> BeamSqlBackendExpressionSyntax be)
-> QGenExpr context be s t
QExpr (forall agg.
IsSql2003EnhancedNumericFunctionsAggregationExpressionSyntax agg =>
Maybe (Sql92AggregationSetQuantifierSyntax agg)
-> agg -> agg -> agg
regrSYYE Maybe (BeamSqlBackendAggregationQuantifierSyntax be)
q forall (f :: * -> *) a b. Functor f => (a -> b) -> f a -> f b
<$> TablePrefix
-> Sql92SelectTableExpressionSyntax
     (Sql92SelectSelectTableSyntax
        (Sql92SelectSyntax (BeamSqlBackendSyntax be)))
x forall (f :: * -> *) a b. Applicative f => f (a -> b) -> f a -> f b
<*> TablePrefix
-> Sql92SelectTableExpressionSyntax
     (Sql92SelectSelectTableSyntax
        (Sql92SelectSyntax (BeamSqlBackendSyntax be)))
y)
regrSXYOver_ :: forall a b be s.
(Num a, Floating b, BeamSqlBackend be, BeamSqlT621Backend be) =>
Maybe (BeamSqlBackendAggregationQuantifierSyntax be)
-> QExpr be s a -> QExpr be s a -> QExpr be s b
regrSXYOver_ Maybe (BeamSqlBackendAggregationQuantifierSyntax be)
q (QExpr TablePrefix
-> Sql92SelectTableExpressionSyntax
     (Sql92SelectSelectTableSyntax
        (Sql92SelectSyntax (BeamSqlBackendSyntax be)))
x) (QExpr TablePrefix
-> Sql92SelectTableExpressionSyntax
     (Sql92SelectSelectTableSyntax
        (Sql92SelectSyntax (BeamSqlBackendSyntax be)))
y) = forall context be s t.
(TablePrefix -> BeamSqlBackendExpressionSyntax be)
-> QGenExpr context be s t
QExpr (forall agg.
IsSql2003EnhancedNumericFunctionsAggregationExpressionSyntax agg =>
Maybe (Sql92AggregationSetQuantifierSyntax agg)
-> agg -> agg -> agg
regrSXYE Maybe (BeamSqlBackendAggregationQuantifierSyntax be)
q forall (f :: * -> *) a b. Functor f => (a -> b) -> f a -> f b
<$> TablePrefix
-> Sql92SelectTableExpressionSyntax
     (Sql92SelectSelectTableSyntax
        (Sql92SelectSyntax (BeamSqlBackendSyntax be)))
x forall (f :: * -> *) a b. Applicative f => f (a -> b) -> f a -> f b
<*> TablePrefix
-> Sql92SelectTableExpressionSyntax
     (Sql92SelectSelectTableSyntax
        (Sql92SelectSyntax (BeamSqlBackendSyntax be)))
y)

covarPop_, covarSamp_, corr_, regrSlope_, regrIntercept_, regrCount_,
  regrRSquared_, regrAvgY_, regrAvgX_, regrSXX_, regrSXY_, regrSYY_
  :: (Num a, Floating b, BeamSqlBackend be, BeamSqlT621Backend be)
  => QExpr be s a -> QExpr be s a -> QExpr be s b
covarPop_ :: forall a b be s.
(Num a, Floating b, BeamSqlBackend be, BeamSqlT621Backend be) =>
QExpr be s a -> QExpr be s a -> QExpr be s b
covarPop_ = forall a b be s.
(Num a, Floating b, BeamSqlBackend be, BeamSqlT621Backend be) =>
Maybe (BeamSqlBackendAggregationQuantifierSyntax be)
-> QExpr be s a -> QExpr be s a -> QExpr be s b
covarPopOver_ forall s. IsSql92AggregationSetQuantifierSyntax s => Maybe s
allInGroup_
covarSamp_ :: forall a b be s.
(Num a, Floating b, BeamSqlBackend be, BeamSqlT621Backend be) =>
QExpr be s a -> QExpr be s a -> QExpr be s b
covarSamp_ = forall a b be s.
(Num a, Floating b, BeamSqlBackend be, BeamSqlT621Backend be) =>
Maybe (BeamSqlBackendAggregationQuantifierSyntax be)
-> QExpr be s a -> QExpr be s a -> QExpr be s b
covarSampOver_ forall s. IsSql92AggregationSetQuantifierSyntax s => Maybe s
allInGroup_
corr_ :: forall a b be s.
(Num a, Floating b, BeamSqlBackend be, BeamSqlT621Backend be) =>
QExpr be s a -> QExpr be s a -> QExpr be s b
corr_ = forall a b be s.
(Num a, Floating b, BeamSqlBackend be, BeamSqlT621Backend be) =>
Maybe (BeamSqlBackendAggregationQuantifierSyntax be)
-> QExpr be s a -> QExpr be s a -> QExpr be s b
corrOver_ forall s. IsSql92AggregationSetQuantifierSyntax s => Maybe s
allInGroup_
regrSlope_ :: forall a b be s.
(Num a, Floating b, BeamSqlBackend be, BeamSqlT621Backend be) =>
QExpr be s a -> QExpr be s a -> QExpr be s b
regrSlope_ = forall a b be s.
(Num a, Floating b, BeamSqlBackend be, BeamSqlT621Backend be) =>
Maybe (BeamSqlBackendAggregationQuantifierSyntax be)
-> QExpr be s a -> QExpr be s a -> QExpr be s b
regrSlopeOver_ forall s. IsSql92AggregationSetQuantifierSyntax s => Maybe s
allInGroup_
regrIntercept_ :: forall a b be s.
(Num a, Floating b, BeamSqlBackend be, BeamSqlT621Backend be) =>
QExpr be s a -> QExpr be s a -> QExpr be s b
regrIntercept_ = forall a b be s.
(Num a, Floating b, BeamSqlBackend be, BeamSqlT621Backend be) =>
Maybe (BeamSqlBackendAggregationQuantifierSyntax be)
-> QExpr be s a -> QExpr be s a -> QExpr be s b
regrInterceptOver_ forall s. IsSql92AggregationSetQuantifierSyntax s => Maybe s
allInGroup_
regrCount_ :: forall a b be s.
(Num a, Floating b, BeamSqlBackend be, BeamSqlT621Backend be) =>
QExpr be s a -> QExpr be s a -> QExpr be s b
regrCount_ = forall a b be s.
(Num a, Floating b, BeamSqlBackend be, BeamSqlT621Backend be) =>
Maybe (BeamSqlBackendAggregationQuantifierSyntax be)
-> QExpr be s a -> QExpr be s a -> QExpr be s b
regrCountOver_ forall s. IsSql92AggregationSetQuantifierSyntax s => Maybe s
allInGroup_
regrRSquared_ :: forall a b be s.
(Num a, Floating b, BeamSqlBackend be, BeamSqlT621Backend be) =>
QExpr be s a -> QExpr be s a -> QExpr be s b
regrRSquared_ = forall a b be s.
(Num a, Floating b, BeamSqlBackend be, BeamSqlT621Backend be) =>
Maybe (BeamSqlBackendAggregationQuantifierSyntax be)
-> QExpr be s a -> QExpr be s a -> QExpr be s b
regrRSquaredOver_ forall s. IsSql92AggregationSetQuantifierSyntax s => Maybe s
allInGroup_
regrAvgY_ :: forall a b be s.
(Num a, Floating b, BeamSqlBackend be, BeamSqlT621Backend be) =>
QExpr be s a -> QExpr be s a -> QExpr be s b
regrAvgY_ = forall a b be s.
(Num a, Floating b, BeamSqlBackend be, BeamSqlT621Backend be) =>
Maybe (BeamSqlBackendAggregationQuantifierSyntax be)
-> QExpr be s a -> QExpr be s a -> QExpr be s b
regrAvgYOver_ forall s. IsSql92AggregationSetQuantifierSyntax s => Maybe s
allInGroup_
regrAvgX_ :: forall a b be s.
(Num a, Floating b, BeamSqlBackend be, BeamSqlT621Backend be) =>
QExpr be s a -> QExpr be s a -> QExpr be s b
regrAvgX_ = forall a b be s.
(Num a, Floating b, BeamSqlBackend be, BeamSqlT621Backend be) =>
Maybe (BeamSqlBackendAggregationQuantifierSyntax be)
-> QExpr be s a -> QExpr be s a -> QExpr be s b
regrAvgXOver_ forall s. IsSql92AggregationSetQuantifierSyntax s => Maybe s
allInGroup_
regrSXX_ :: forall a b be s.
(Num a, Floating b, BeamSqlBackend be, BeamSqlT621Backend be) =>
QExpr be s a -> QExpr be s a -> QExpr be s b
regrSXX_ = forall a b be s.
(Num a, Floating b, BeamSqlBackend be, BeamSqlT621Backend be) =>
Maybe (BeamSqlBackendAggregationQuantifierSyntax be)
-> QExpr be s a -> QExpr be s a -> QExpr be s b
regrSXXOver_ forall s. IsSql92AggregationSetQuantifierSyntax s => Maybe s
allInGroup_
regrSYY_ :: forall a b be s.
(Num a, Floating b, BeamSqlBackend be, BeamSqlT621Backend be) =>
QExpr be s a -> QExpr be s a -> QExpr be s b
regrSYY_ = forall a b be s.
(Num a, Floating b, BeamSqlBackend be, BeamSqlT621Backend be) =>
Maybe (BeamSqlBackendAggregationQuantifierSyntax be)
-> QExpr be s a -> QExpr be s a -> QExpr be s b
regrSYYOver_ forall s. IsSql92AggregationSetQuantifierSyntax s => Maybe s
allInGroup_
regrSXY_ :: forall a b be s.
(Num a, Floating b, BeamSqlBackend be, BeamSqlT621Backend be) =>
QExpr be s a -> QExpr be s a -> QExpr be s b
regrSXY_ = forall a b be s.
(Num a, Floating b, BeamSqlBackend be, BeamSqlT621Backend be) =>
Maybe (BeamSqlBackendAggregationQuantifierSyntax be)
-> QExpr be s a -> QExpr be s a -> QExpr be s b
regrSXYOver_ forall s. IsSql92AggregationSetQuantifierSyntax s => Maybe s
allInGroup_