题解 | #统计作答次数#
统计作答次数
https://www.nowcoder.com/practice/45a87639110841b6950ef6a12d20175f
SELECT COUNT(1) total_pv, COUNT(score) complete_pv,
COUNT(DISTINCT CASE WHEN submit_time IS NOT NULL THEN exam_id END)
FROM exam_record
DISTINCT 与 CASE WHEN 共同使用时需要将DISTINCT放最前面
投递OPPO等公司10个岗位
