如何在Laravel查询生成器中按首字母计数？

香兰笑

我想按首字母计数...我有此专栏
. ^. J6 E  y: x6 k8 ]1 e: i" c我想计算每一个OE行和每个GICS行
我正在使用这个查询
$data4 = DB::table('incidencias')   ->select(DB::raw('grupo_asig as grupo_asig'),DB::raw('count(*) as number)  ->whereNotIn('grupo_asig->groupBy('grupo_asig')   ->orderBy('number','desc')   ->get()；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；
* H5 p2 A9 f; a    解决方案: