avg method

Future<DbResponse> avg(
  1. List<Avg> avg, {
  2. Where? where,
}) 
  avg([Avg("amount",)]);
  avg([Acg("amount", label: "averageAmount")], where: Where("age",WhereOperator.isGreaterThan , 40));

Implementation

Future<DbResponse> avg(
  List<Avg> avg, {
  Where? where,
}) async {
  String query =
      'SELECT ${(avg.map((e) => e.query)).map((val) => '"$val"').join(', ')} FROM "$tableName" ${getQuery(where: where)}';
  var dbRes = await db.query(query);

  return DbResponse(
      dbRes.columnDescriptions.map((e) => e.columnName).toList(),
      List<List>.from(dbRes.toList()));
}