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