[SQL문제풀기] 최근 올림픽이 개최된 도시

문제

solvesql.com

https://solvesql.com/problems/olympic-cities/

SQLite

내가 작성한 정답

select year, upper(substr(city,1,3)) city
from games
where year >= 2000
order by year desc;