Thought I would add my solution to the thread here.
Cheers.
Thought I would add my solution to the thread here.
Cheers.
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 if you have found it helpful please.
Thanks!
Here are my solutions. Any comments are welcome!
Here is my attempt at it