رتبه بندی

کد:

select p_id, (sum(nums) / count(nums)) as _av from nums
group by p_id
order by _av desc