[SQL문제풀기] Activity Rank

문제

StrataScratch - Activity Rank

StrataScratch

https://platform.stratascratch.com/coding/10351-activity-rank?code_type=1

내가 작성한 정답

MySQL, PostgreSQL, Oracle

select from_user, count(id) total_emails, row_number() over(order by count(id) desc, from_user) activity_rank
from google_gmail_emails
group by from_user;