with cte as ( select device_id,university,gpa, avg(gpa)over(partition by university) as avg_gpa from user_profile ) select device_id,university from cte where gpa>avg_gpa and avg_gpa>3.6 order by device_id desc