4.4.7 聚合函数

4.4.7 聚合函数

• count()：统计数量
• min()：最小值
• max()：最大值
• sum()：总和
• avg()：平均值

<?php
namespace App\Controller;

class IndexController extends AbstractController
{
    public function index()
    {
        return [
            'count' => \App\Model\UserActivity::query()->count(),
            'min' => \App\Model\UserActivity::query()->min('id'),
            'max' => \App\Model\UserActivity::query()->max('id'),
            'sum' => \App\Model\UserActivity::query()->sum('id'),
            'avg' => \App\Model\UserActivity::query()->avg('id'),
        ];
    }
}

输出：
  {
      "count": 6,
      "min": 10015,
      "max": 10029,
      "sum": "60125",
      "avg": "10020.8333"
  }