Group By dengan Count & Order By in laravel(英语：Count & Order By in laravel)

Question

请帮忙SELECT CUSTOMER, COUNT(USER_ID) FROM ticket_table GROUP BY CUSTOMER ORDER BY COUNT(USER_ID) DESC LIMIT 10;对于以下查询，当在Laravel查询生成器中实现时，它是什么类型的控制器？

Answer 1

你的意思是这样的吗：

DB::table('ticket_table')
->selectRaw('customer, count(user_id)')
->groupBy('customer')
->orderBy(DB::raw('COUNT(user_id)'), 'DESC')
->limit(10);