CODE EXAMPLE FOR PHP

orderby not working with groupby laravel

$devices = Device::groupBy('serial_no')->orderByDesc('serial_no')->get();

++++++++++++++++++++ SQL QUERY +++++++++++++++

SELECT sum(in_stock) stock, some_field2, some_field3
FROM some_table
GROUP BY some_field2, some_field3
ORDER BY some_field1