Guided Project: CIA Factbook with few own extra queries

Basics.ipynb (73.8 KB)

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

1 Like

Nice queries.

Maybe you could do like this for all populations–
(population)/1000000, it makes it more readable

I saw it at sql zoo under number 3
https://sqlzoo.net/wiki/SELECT_from_WORLD_Tutorial?answer=1

SELECT *,(SELECT CAST(ROUND(AVG(population)/1000000, 0)AS INT) FROM facts) ‘average pop(M)’