[MySQL] (Medium) Ranking Most Active Guests

문제: https://platform.stratascratch.com/coding/10159-ranking-most-active-guests?code_type=3

나의 풀이:

select id_guest
     , dense_rank() over (order by sum(n_messages) desc) as ranks
     , sum(n_messages) as messages
from airbnb_contacts
group by id_guest
order by 3 desc;

 

솔루션:

select id_guest, 
dense_rank() over (order by sum(n_messages) desc) as ranks, sum(n_messages) messages
from airbnb_contacts
group by id_guest
order by messages desc;

 

굿굿!