摘要： 法一： select count(distinct if(submit_time is not null, exam_id, null)) as complete_exam_cnt from exam_record 法二： SELECT count(distinct exam_id and scor 阅读全文