为提高效率，提问时请提供以下信息，问题描述清晰可优先响应。
【DM版本】:安全版8
【操作系统】：麒麟
【CPU】:
【问题描述】*：
SELECT t.class_name, t.student_name, t.survey_id, t.answer_common_id, (CASE WHEN t.bringsId IS NULL THEN '0' WHEN t.answer_common_id IS NULL THEN 1 ELSE 2 END) AS status, (CASE WHEN t.bringsId IS NULL THEN '暂无数据' WHEN t.answer_common_id IS NOT NULL THEN t.commonContent ELSE t.infoContent END) AS content FROM (SELECT ssi.id, sci.name AS class_name, ssi.name AS student_name, (SELECT c.content FROM sps_answer_common c WHERE c.is_deleted = 0 AND c.survey_id = ssp.id AND c.answer_user = ssi.user_id ORDER BY c.update_time DESC LIMIT 1) AS commonContent, (SELECT c.id FROM sps_answer_common c WHERE c.is_deleted = 0 AND c.survey_id = ssp.id AND c.answer_user = ssi.user_id ORDER BY c.update_time DESC LIMIT 1) AS answer_common_id, sci.two_brings_id AS bringsId, sui.content AS infoContent, ssp.id AS survey_id FROM sps_student_info ssi LEFT JOIN sps_class_info sci ON ssi.class_id = sci.id AND sci.is_deleted = 0 LEFT JOIN sps_survey_info sui ON sci.two_brings_id = sui.id AND sui.is_deleted = 0 LEFT JOIN sps_survey_plan ssp ON sci.id = ssp.target_class_id AND sci.two_brings_id = ssp.paper_id AND ssp.is_deleted = 0 AND ssp.survey_type = 1 AND ssp.scope = 3 LEFT JOIN sps_answer_common sac ON ssi.user_id = sac.answer_user AND ssp.id = sac.survey_id AND sac.is_deleted = 0 WHERE ssi.user_id = ? AND ssi.class_id = ? AND ssi.is_deleted = 0 GROUP BY ssi.id) t

这段SQL我已经在select中写上了ssi.id，发现不管用，然后执行了ALTER SYSTEM SET 'GROUP_OPT_FLAG'=1 BOTH;命令重启应用和数据库服务都不行，求解...谢谢