SELECT 
    COUNT(start_time) AS total_pv,
    COUNT(submit_time) AS complete_pv,
    (
        SELECT COUNT( DISTINCT exam_id)
        FROM exam_record
        WHERE submit_time IS NOT NULL
    ) AS complete_exam_cnt
FROM exam_record
  • 使用子查询