题解 | #统计作答次数#

select

count(uid) as total_pv

,count( case when submit_time is not null and score is not null

then uid else null end ) as complete_pv

,count(distinct case when submit_time is not null and score is not null then exam_id else null end ) as complete_exam_cnt

from exam_record

group by null