select count(start_time)as total_pv,sum(case when submit_time is not null and score is not null then 1 else 0 end)as complete_pv,
count(distinct exam_id and score is not null)as complete_exam_cnt
from exam_record
select count(start_time)as total_pv,sum(case when submit_time is not null and score is not null then 1 else 0 end)as complete_pv,
count(distinct exam_id and score is not null)as complete_exam_cnt
from exam_record
牛客博客，记录你的成长
京公网安备 11010502036488号