题解 | #筛选昵称规则和试卷规则的作答记录#
筛选昵称规则和试卷规则的作答记录
http://www.nowcoder.com/practice/1c5075503ccf4de1882976b2fff2c072
SELECT ui.uid,er.exam_id,ROUND(AVG(score)) avg_score
FROM exam_record er INNER JOIN user_info ui ON er.uid=ui.uid
INNER JOIN examination_info ei ON ei.exam_id=er.exam_id
WHERE (nick_name RLIKE '^牛客[0-9]+号$'
OR nick_name RLIKE '^[0-9]+$')
AND tag RLIKE '^[cC]'
AND submit_time is not null
GROUP BY ui.uid,er.exam_id
FROM exam_record er INNER JOIN user_info ui ON er.uid=ui.uid
INNER JOIN examination_info ei ON ei.exam_id=er.exam_id
WHERE (nick_name RLIKE '^牛客[0-9]+号$'
OR nick_name RLIKE '^[0-9]+$')
AND tag RLIKE '^[cC]'
AND submit_time is not null
GROUP BY ui.uid,er.exam_id
ORDER BY uid,avg_score
不知道为什么牛客1号不算。如果改成'[0-9]+$',就会把牛客1号算进来。困惑。
投递完美世界等公司10个岗位 >