题解 | 筛选昵称规则和试卷规则的作答记录
筛选昵称规则和试卷规则的作答记录
https://www.nowcoder.com/practice/1c5075503ccf4de1882976b2fff2c072
select ui.uid,er.exam_id, round(avg(score),0) as avg_score from user_info ui join exam_record er on ui.uid = er.uid join examination_info ei on ei.exam_id = er.exam_id where (nick_name rlike '^牛客[0-9]+号$' or nick_name rlike'^[0-9]+$') and submit_time is not null and tag rlike '^c|C' group by ui.uid,er.exam_id order by ui.uid,avg_score
学习rlike
