题解 | #统计作答次数#

SELECT 
    COUNT(1) total_pv,
    COUNT(score) complete_pv,
    (SELECT 
            COUNT(DISTINCT (exam_id))
        FROM
            exam_record
        WHERE
            score IS NOT NULL) complete_exam_pv
FROM
    exam_record;