Challenges_
Explore a question, follow the analyst brief, and build an answer with open data.
Which AI data-center milestones are still in the future?
Practice CASE, CURRENT_DATE and JOIN with Epoch AI site milestones and capacity estimates.
Gapminder: Wealth and health of nations
Practice joining four tables by country and year to build a Hans Rosling-style bubble chart of GDP per capita, life expectancy and population, colored by region and animated by year.
Do richer countries receive more tourists?
Compare international arrivals with GDP per capita using a country-year JOIN.
When did Toronto inspections most often need follow-up?
Practice grouping DineSafe outcomes by year and calculating a share from source records.
Where and when are sea turtles reported most often?
Practice grouping reported sea turtle encounters by year, event type and location.
Which countries welcome the most tourists per resident?
Practice a country-year JOIN and ratio using tourism arrivals and population.
Do higher-income countries have fewer children?
Practice joining GDP per capita with fertility rate by country and year, then compare the two measures.
Do richer countries always live longer?
Practice joining GDP per capita with life expectancy by country and year, then compare their relationship.
Is inflation different inside and outside the EU?
Practice joining inflation with UN M49 Europe and classifying EU membership at the observation year's end.
Is lower perceived corruption linked to higher GDP per capita?
Practice joining CPI scores with GDP per capita by country and year, then compare perception scores with economic output.
Must high human development mean high CO₂ emissions?
Practice joining HDI with per-person CO₂ emissions by country and year, then inspect the exceptions.
Can GDP per capita and population estimate total GDP?
Practice joining GDP per capita and population by country and year, then calculate an estimated total GDP.
How has GDP per capita changed in South-eastern Asia?
Practice joining annual GDP per capita with UN M49 geography and comparing South-eastern Asian trends.
Where are NATO members located?
Practice joining NATO membership with UN M49 geography and counting countries by region.