Olympics history project with SQL

Main goal of this project is to show my skills using SQL.
In this task I have used CTE, window functions, coalesce, crosstab(pivoting)...