题解 | #北京大学或练题数大于2的学生ID#
北京大学或练题数大于2的学生ID
https://www.nowcoder.com/practice/b2b639586d89409b9c1fa82c083287dd
select device_id
from
user_profile as up
where
university = '北京大学'
union
select
device_id
from
question_practice_detail as qp
group by device_id
having count(device_id)>2
order by device_id desc
查看11道真题和解析
