avg<T extends SqlType> static method

QSelectField avg<T extends SqlType>(
  1. QField alias
)

Creates an AVG aggregate function with optional alias. alias A QField that specifies the field to average and optional alias. Returns a QSelectField representing the AVG function.

Implementation

static QSelectField avg<T extends SqlType>(QField alias) {
  String as = alias.as.isNotEmpty ? ' AS ${QField(alias.as).toSQL<T>()}' : '';

  String field = QField(alias.value, distinct: alias.distinct).toSQL<T>();
  return QMath('AVG($field)$as');
}