生成一句含有三个函数的select语句

好的，下面是一句含有三个函数的select语句：

SELECT CONCAT(UPPER(last_name), ', ', LOWER(first_name)), DATE_FORMAT(birth_date, '%Y-%m-%d'), COUNT(*) FROM employees GROUP BY last_name, first_name HAVING COUNT(*) > 1 ORDER BY COUNT(*) DESC;