max case when: https://blog.csdn.net/weixin_28686771/article/details/113200723 group_concat:https://chengbo.blog.csdn.net/article/details/90383022?spm=1001.2101.3001.6650.3&utm_medium=distribute.pc_relevant.none-task-blog-2%7Edefault%7EESLANDING%7Edefault-3-90383022-blog-106852951.pc_relevant_landingrelevant&depth_1-utm_source=distribute.pc_relevant.none-task-blog-2%7Edefault%7EESLANDING%7Edefault-3-90383022-blog-106852951.pc_relevant_landingrelevant&utm_relevant_index=6