SELECt student_id, section, sum(case when response=1 then 1 else 0 end) as totalFROM raw_data_r GROUP BY student_id, section
请注意，没有
WHERe条件。
SELECt student_id, section, sum(case when response=1 then 1 else 0 end) as totalFROM raw_data_r GROUP BY student_id, section
请注意，没有
WHERe条件。
名师互学网 版权所有 (c)2021-2022 ICP备案号：晋ICP备2021003244-6号
