select u.device_id,u.university from user_profile u,( select university,avg(gpa) as avg_gpa from user_profile group by university having avg(gpa)>3.6 ) as a where a.avg_gpa<u.gpa and a.university=u.university order by device_id desc;