猫波波

题解

/ 注册

全部文章 / 题解（共2篇）

题解 | 应该是对的吧

SELECT uid, nick_name, achievement FROM user_info WHERE nick_name LIKE '牛客%号' AND achievement BETWEEN 1200 AND 2500 AND uid IN ( ...

2022-01-14

32 1749

题解 | #满足条件的用户的试卷完成数和题目练习数#

SELECT temp.uid, COUNT(DISTINCT er.id) AS exam_cnt, COUNT(DISTINCT pr.id) AS question_cnt FROM ( SELECT uid FROM exam_record J...

2022-01-07

10 599