题解 | #筛选昵称规则和试卷规则的作答记录#

这题考察的是正则表达式。

正则表达式这个知识点还没有掌握。

select uid,
exam_id,
round(avg(score), 0) as avg_score from exam_record
where uid in (
    select uid
    from user_info
    where nick_name rlike '^牛客[0-9]+号$' or nick_name rlike '^[0-9]+$' )
    and exam_id in (
        select exam_id
        from examination_info
        where tag rlike '^[cC]'
    )
    and score is not null
group by uid, exam_id
order by uid, avg_score