这里是我的MySQL查询(在phpMyAdmin中工作):
SELECT workcenter,(SUM(w1+w2 +w3 +w4)/ (COUNT(DISTINCT(teknisi))*40*4) )*100 AS total FROM `team` GROUP by workcenter ORDER BY total
然后,我在下面尝试这样的Laravel Sintax(不起作用):
$sql = Team::groupBy('workcenter')->select('workcenter',\DB::raw('(SUM(w1+w2+w3+w4)/ (COUNT(DISTINCT(teknisi))*30*4) )*100 AS total'))
->OrderBy('total','Desc')
->get();
当我运行laravel sintax时,它没有显示任何错误,但是输出为空。