World Populations Challenge Project (SQL)


Here is my code and I hope it is helpful! let me know if there is any question.

Here is my solution to World populations SQL Practice Challenge I

Here’s my solution to the challenge.

Here’s my solution to the WPC Project (SQL). Do take a look :smile:

Can someone tell how the difference would work (in Q8). I calculated manually for now.
Thanks!

Here’s my solution!

here is mine

THIS IS MY SOLUTION

Hi! Here is my solution to the project: Feel free to see how mine fairs against yours!

Here is my Solution for the first sql challenging project.

Hello all! I am showing my solutions here, about project I. Any feedback or interaction here or on GitHub would be so appreciated!

Excellent Challenge Project.

This is my solutions!

Hello!
First Project done.

I thought outside the box in the last one.
Please tell me how I could have solved it with less effort.

Thank you!

Thanks for this support!!

Hi, is it my code correct?
Could you guy give me some advice?
Thank you you guy in advance.

I’M SORRY FOR ASKING,
how can i see the solution.
i downloaded file of solution which is given,
but it is just a database. there is no solution.

HERE IS MY SOLUTION I WANT TO COMPARE MINE WITH SOLUTION… THAT’S WHY I NEED HELP.

–Q3. What years are covered by the dataset?

SELECT DISTINCT year from population_years;

–A3. from 2000 to 2010 total 11years recorded

–Q4. What is the largest population size for Gabon in this dataset?

select * from population_years

where country = ‘Gabon’

order by population desc

limit 1;

–A4. on 2010, 1.54526 recorded

–Q5. What were the 10 lowest population countries in 2005?

select * from population_years

where year = ‘2005’

order by population

limit 10;

–A5. FROM the lowest,

–Niue, Falkland, Montserrat, Saint Pierre and Miquelon, Saint Helena, Nauru, Cook Islands, Turks and Caicos Islands, Virgin Islands, Gibraltar

–Q6. What are all the distinct countries with a population of over 100 million in the year 2010?

select distinct country, population, year

from population_years

where population >= 100

and year = ‘2010’;

–A6. Mexico, United States, Brazil, Russia, Nigeria, Bangladesh, China, India, Indonesia, Japan, Pakistan

–Q7. How many countries in this dataset have the word “Islands” in their name?

select distinct country

from population_years

where country like “%Islands%”;

–A7. Total 7. Cayman Islands, Falkland Islands (Islas Malvinas), Turks and Caicos Islands, Virgin Islands, U.S., Virgin Islands, British, Faroe Islands, Cook Islands, Solomon Islands, U.S. Pacific Islands

–Q8. What is the difference in population between 2000 and 2010 in Indonesia?

select *

from population_years

where (country = ‘Indonesia’ and year = 2000)

or (country = ‘Indonesia’ and year = 2010);

–A8. in 2000: 214.67661 in 2010: 242.96834 so the difference is 28.29173(million)