题解 | 统计作答次数
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
查看5道真题和解析
小天才公司福利 1159人发布