Olympics Data Analysis

Analyzing the Olympics dataset using PostgreSQL SQL queries.

Table of Contents

• Problem Solving
• Files
• Getting Started
• Conclusion

Problem Solving

In this project, I have tackled the following 20 problems using the Olympics dataset:

1. How many Olympics games have been held?
2. List down all Olympics games held so far.
3. Mention the total number of nations that participated in each Olympics game.
4. Which year saw the highest and lowest number of countries participating in Olympics?
5. Which nation has participated in all of the Olympic games?
6. Identify the sport that was played in all summer Olympics.
7. Which sports were played only once in the Olympics?
8. Fetch the total number of sports played in each Olympic game.
9. Fetch details of the oldest athletes to win a gold medal.
10. Find the ratio of male and female athletes participated in all Olympic games.
11. Fetch the top 5 athletes who have won the most gold medals.
12. Fetch the top 5 athletes who have won the most medals (gold/silver/bronze).
13. Fetch the top 5 most successful countries in Olympics based on the number of medals won.
14. List down the total gold, silver, and bronze medals won by each country.
15. List down the total gold, silver, and bronze medals won by each country corresponding to each Olympic game.
16. Identify which country won the most gold, most silver, and most bronze medals in each Olympic game.
17. Identify which country won the most gold, most silver, most bronze medals, and the most medals in each Olympic game.
18. Which countries have never won a gold medal but have won silver/bronze medals?
19. In which sport/event, India has won the highest number of medals.
20. Break down all Olympic games where India won a medal for Hockey and indicate how many medals were won in each Olympic game.

Files

• All questions.sql: Contains the SQL queries used to solve the problems mentioned above.

Getting Started

To run these queries, follow these steps:

1. Install PostgreSQL on your system if not already done.
2. Create a database and import the Olympics dataset.
3. Open a SQL client (e.g., pgAdmin) and execute the queries in the queries.sql file.

Conclusion

This project demonstrates the application of SQL queries on the Olympics dataset to extract valuable insights and answers to specific questions. The queries provide a deeper understanding of the historical Olympic data and showcase the capabilities of SQL for data analysis.