routine group mysql code example

Example 1: mysql group by day

GROUP BY DATE_FORMAT(record_date, '%Y%m')

Example 2: MySQL GROUP BY

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