关于关联查询数据统计排序的问题 ?

原生语句

SELECT 
COUNT (record.cid) AS records, 
course.name 
FROM 
course 
LEFT JOIN record ON record.cid = course.id 
GROUP BY 
course.name 
ORDER BY 
records

DB格式

DB::table('course')
->leftjoin('record', 'record.cid', '=', 'course.id')
->selectRaw('COUNT(record.cid) AS records, course.name')
->groupBy('course.name')
->orderBy('records', 'desc')
->get();

@一个人的江湖

@青风百里 谢谢,非常感谢:pray:

@青风百里 大神,帮忙看下这个
问答：关于关联查询的问题 ?