✅The data has been extracted from popular platform kaggle(thanks to the original owner)
➡️Link to the dataset: https://www.kaggle.com/datasets/heesoo37/120-years-of-olympic-history-athletes-and-results
✅We've analyzed the data using simple to complex SQL queries to find answers to 20 questions.
✅The list of question are contained in 'Queriess.txt' file in the 'Olympics Project->Queries' folder.
🛠️Concepts used:
- conditional data retrieval(case clause)
- window functions(e.g. first_value, last_value etc.)
- cte(Common Table Expressions)
- pivoting
- joins
- subqueries
- aggregation(group by clause)
- sorting(order by clause)
Note: I've written all the queries as per MySQL RDBMS notations.