[SQL문제풀기] Top Businesses With Most Reviews

문제

StrataScratch - Top Businesses With Most Reviews

StrataScratch

https://platform.stratascratch.com/coding/10048-top-businesses-with-most-reviews?code_type=7

내가 작성한 정답

MySQL, PostgreSQL, Oracle

select name, review_count
from (select name, review_count, rank() over(order by review_count desc) ro
        from yelp_business) a
where ro <= 5
order by ro;