avg static method

QSelectField avg(
  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(QField alias) {
  String as = alias.as.isNotEmpty ? ' AS ${QField(alias.as).toSQL()}' : '';

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