연습문제6) 팀 프로젝트 열심히 했으니 다시 놀아볼까요?!

 

 

select *,

rank() over(order by rating desc) 'rank'

from practice6

 

 

select *

from practice6 p

order by end_date desc

limit 1

 

select *

from practice6 p

order by region, rating desc

 

 

select region,

avg(rating)

from practice6 p

group by region