World Populations Challenge Project (SQL)

Thought I would add my solution to the thread here.

Cheers.

mine

Hello all!

Here’s my solution!

Greetings to everybody
Here’s my Solution to the World Population Challenge Project:

My Solution To the Worldd Populations SQL Practice

Mine. If someone can could guide me how to upload this code to my github profile, I will be grateful. Thanks

Sharing my work!

Hello all,

here is the link to my github repository containing the database and the sql file:

Cheers

Simon

new link:

– This is the first query:

SELECT DISTINCT year from population_years;

– Add your additional queries below:
SELECT * FROM population_years
WHERE country LIKE ‘Gabon’
ORDER BY population DESC
LIMIT 1;

SELECT * FROM population_years
WHERE year = 2005
ORDER BY population ASC
LIMIT 10;

SELECT DISTINCT country FROM population_years
WHERE year = 2010 and population >= 1000.00000;

SELECT COUNT (country) FROM population_years
WHERE country LIKE ‘%Islands%’;

SELECT population FROM population_years
WHERE year = 2000 AND country LIKE ‘Indonesia’;

SELECT population FROM population_years
WHERE year = 2010 AND country LIKE ‘Indonesia’;

Added my results and working.

That was a fun project to practice Manipulation and Queries skills!

Below are the queries for the ‘World Populations Challenge’ Project

Please check it out and provide feedback.

Below I share the answers for the “World Populations SQL Practice I”.

This is my very first post here on the platform, so be sure to give it some :heart: if you have found it helpful please.

Thanks! :grinning:

1 Like

Here are my solutions. Any comments are welcome!

Here is my attempt at it :slight_smile:

Population years