WITH avg_gpa AS( SELECT university,AVG(gpa) avg_g FROM user_profile GROUP BY university HAVING AVG(gpa) >3.6 ) SELECT t1.device_id,t1.university FROM user_profile t1 INNER JOIN avg_gpa t2 ON t1.university = t2.university WHERE t1.gpa > t2.avg_g ORDER BY device_id DESC