题解 | #筛选昵称规则和试卷规则的作答记录#
筛选昵称规则和试卷规则的作答记录
https://www.nowcoder.com/practice/1c5075503ccf4de1882976b2fff2c072
select
uid,
exam_id,
round(avg(score)) as avg_score
from
user_info
join exam_record using (uid)
join examination_info using (exam_id)
where
nick_name regexp ('牛客\\d+号$|^\\d+$')
and tag regexp ('^[cC]')
and score is not null
group by
uid,
exam_id
order by uid,avg_score
三个表连接之后用正则做一个条件筛选即可。
