World Populations Challenge Project (SQL)

Here’s my solution! Although, the questions seem to be different from others.

https://gist.github.com/27c331cd3005bdb04b9c5295a5d79dc6 - Please have a look at my code

Thanks!


this is my solution ! Please help me to check it. Thank you


Hello, please check on my code :slight_smile:
Hope it is okay :slight_smile:

Here’s my solution to questions:

Here’s mine: https://gist.github.com/20a27f1bf3f096d9fb4a143215f54c43

The thing is, I set up everything on GitHub according to the article linked above. However, I am stuck on how to get my work into my repository on GitHub. Like I’ve created a repository and all that, but I can’t find any instructions on how to get my project from the code editor in Codecademy to my repository. I’m a very early beginner in this and I’m quite lost, so any help would be appreciated!

My solution :slight_smile:

This is how I answered this question as well! Except a little shorter… here’s my code:

SELECT MAX(population)
FROM population_years
WHERE country = “Gabon”;

Since it didn’t ask which year the largest population size was from in the dataset, I didn’t use the solution that most everyone else who previously posted used. You still get the same answer for population size. :wink:

Hey, here’s another solution to the final question, no need to work it out yourself.

1 Like

How are you all doing? here is my solution to the World Populations Challenge Project(SQL) I.
please let me know if I’m missing something. Thanks.

Hello,

These are my queries for part 1 word of population SQL practice:

select max(population) as ‘4’ from population_years where country = ‘Gabon’;

select country as ‘5’ from population_years where year = 2005 order by population asc limit 10;

select distinct country as ‘6’ from population_years where year = 2010 and population > 100;

select count(*) as ‘7’ from (select distinct country from population_years) where country like ‘%islands%’;

select (max(population) - min(population)) from population_years where year between 2000 and 2010 and country = ‘Indonesia’;

Hey everybody. My solution is here

this is my solution!

https://gist.github.com/cd2d4e714889eb4eb39a5785ea6faa4d

This is my solution!

1 Like