题解 | 北京大学或练题数大于2的学生ID

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