在版本5中运行包含除法的mysql查询 - running a mysql query containing division in laravel 5

running a mysql query containing division in laravel 5

我想在Laravel 5中使用DB查询运行这个mysql查询:

// SELECT *, rating/number as total FROM `courses` order by total DESC;

这是我尝试过的:

$query   = 'DB::table('courses')->select('*');
$courses = $query->addSelect('rating/number as total')
                 ->orderBY('total DESC')
                 ->get();

但是，rating/number被认为是一个表列。当我在括号内(评级/数字)尝试时，也发生了同样的事情。任何帮助吗?

$courses = 'DB::table('courses')
              ->selectRaw('*, rating/number as total')
              ->orderBY('total', 'DESC')
              ->get();

可以使用Raw表达式吗?也许像这样:

$courses = 'DB::table('courses')
                 ->select(DB::raw('*, (rating / number) as total'))
                 ->orderBy('total DESC')
                 ->get();