order by group by mysql code example

Example 1: MySQL GROUP BY

SELECT 
    c1, c2,..., cn, aggregate_function(ci)
FROM
    table
WHERE
    where_conditions
GROUP BY c1 , c2,...,cn;

Example 2: MySQL GROUP BY

SELECT Manufacturer, COUNT(*) AS ModelsCount
FROM Products
WHERE Price > 30000
GROUP BY Manufacturer
ORDER BY ModelsCount DESC

Example 3: mysqli query order by before group by

//it is vary difficult to find a query that uses Order By before Group By
//so, below is the query when you want to first order the results in Asc (min) or Desc (max) order, and then Group by
$raw_query = 'SELECT p1.* FROM table1 p1
         INNER JOIN ( SELECT max(firstValue) MaxAnyId, secondValue
                            FROM table1
                            WHERE user_id=162
                               AND status_id=70
                            GROUP BY secondValue
                        ) p2
                          ON p1.secondValue = p2.secondValue
                          AND p1.firstValue = p2.MaxLogId
                        WHERE p1.user_id=162
                          AND p1.status_id=70
                        order by p1.firstValue desc';
                        
//for Laravel ->                        
$q = \DB::select($raw_query);