题解 | 统计作答次数
select
count(*) total_pv,
count(
case
when submit_time then 1
end
) complete_pv,
count(
distinct case
when submit_time then exam_id
end
) complete_exam_cnt
from
exam_record
吉比特公司福利 258人发布