avg method

Future<double?> avg(
  1. String tableName,
  2. String column
)

Implementation

Future<double?> avg(String tableName, String column) async {
  final result = await _database.rawQuery('SELECT AVG($column) FROM $tableName');
  if (result.isNotEmpty && result.first.values.first != null) {
    return (result.first.values.first as num).toDouble();
  }
  return null;
}