题解 | #筛选昵称规则和试卷规则的作答记录#
筛选昵称规则和试卷规则的作答记录
https://www.nowcoder.com/practice/1c5075503ccf4de1882976b2fff2c072
select ui.uid,ei.exam_id,round(avg(score),0) avg_score from user_info ui,examination_info ei,exam_record er
where ui.uid = er.uid and ei.exam_id = er.exam_id
and (nick_name regexp '^牛客+[0-9]+号$'
or nick_name regexp '^[0-9]+')
and tag regexp '^c'
and submit_time is not null
group by ui.uid,ei.exam_id
order by ui.uid,avg(score);
比亚迪工作强度 365人发布
投递拼多多集团-PDD等公司10个岗位
360集团二面32人在聊
查看5道真题和解析