MySQL 5.7 | GROUP BY |非聚合列错误

I upgraded our mysql db from 5.6 to 5.7 and am in the process of fixing some queries which are throwing some errors. One of the queries I am working involves a GROUP BY with a COALESCE.I upgraded our mysql db from 5.6 to 5.7 and am