Olympics Results Exploration Using SQL
SQL | MS SQL Server
- Perform Complex Data Queries: Write intricate SQL queries that go beyond simple SELECT statements, utilizing JOINs, GROUP BY, HAVING, and window functions to aggregate and analyze data.
- Answer Analytical Questions: Formulate and execute queries to answer a variety of questions, such as:
-
Which athlete has won the most medals in a specific sport or of all time?
-
How has a particular country's medal count evolved over the history of the Games?
-
What is the distribution of gold, silver, and bronze medals across different sports or years?
-
Which events have the most participants, and how does this correlate with medal counts?
-
Identify the youngest or oldest medal winners in Olympic history.