SELECT u.device_id,s.question_id,s.result from (select *from user_profile where university='浙江大学') u 
left join question_practice_detail s
on u.device_id=s.device_id
order by s.question_id ASC;