我正在尝试执行下一个SQL查询：

SELECT  sex, recuperated, count(case_id) as total_cases
FROM api.patients
GROUP BY recuperated, sex
ORDER BY total_cases DESC;

返回：

'41523', 'ANTIOQUIA', 'MEDELLIN'
'6066', 'ANTIOQUIA', 'BELLO'
'6056', 'AMAZONAS', 'LETICIA'
'3855', 'ANTIOQUIA', 'ITAGUI'

首先是雄辩的：

$query = Patient::query();    
$statistics[0] = $query
->select("sex", "recuperated", "count (case_id) as total_cases")
->orderBy("total_cases","desc")
->groupBy("recuperated")
->get();

它返回：

照明\数据库\查询异常SQLSTATE[42S22]：未找到列： 1054未知列'total_cases'在'顺序子句'（SQL：选择计数（*）作为聚合从<代码>患者组按<代码>休养，<代码>性按<代码>顺序>total_casesdesc）

雄辩的第二位：

$query = Patient::query();    
$statistics[0] = $query
->select('sex','recuperated',DB::raw('count(case_id) AS   total_cases'))
        ->orderBy('total_cases','DESC')
        ->groupBy('recuperated')
        ->get();