题解 | 北京大学或练题数大于2的学生ID
北京大学或练题数大于2的学生ID
https://www.nowcoder.com/practice/b2b639586d89409b9c1fa82c083287dd
SELECT device_id
FROM user_profile
WHERE device_id IN(
SELECT DISTINCT device_id
FROM question_practice_detail
GROUP BY device_id
HAVING COUNT(question_id) > 2
)
OR university = '北京大学'
ORDER BY device_id DESC
腾讯云智研发公司福利 112人发布