Guided Project CIA factbook with extra query

  1. I was not able to get the mission to work with my own Jupyter, so I just completed it through the DataQuest interface. I thought it was a good lesson other than the Jupyter issue. I went beyond the mission to look at some queries that related population and area to birth and death rates. I was surprised to see what countries had above average death rate with most dense population. Take a look at my results and tell me what you think.

  2. https://app.dataquest.io/m/257/guided-project%3A-analyzing-cia-factbook-data-using-sql/8/next-steps

  3. Basics.ipynb (166.7 KB)

    Click here to view the jupyter notebook file in a new tab

1 Like

Just some feedback - it takes a long time to scroll through this table you might want to use LIMIT()

%%sql 
SELECT *
  FROM facts;