Complex SQL query example

SELECT date_format(birthday,'%c') AS `Month`,
       COUNT(name) AS `Total`,
       group_concat(name,date_format(birthday,'(%d/%m/%Y)')) AS `Details`
FROM friends
GROUP BY MONTH(birthday)
ORDER BY MONTH(birthday);