World Populations SQL Practice II

gouravjain07 · October 14, 2020, 3:27pm

Here is my solution to World Populations SQL Practice II

gist.github.com

https://gist.github.com/codecademydev/22e779b45cca96e7565f5027e26624a1

population_queries.sqlite

SELECT * FROM countries WHERE name = 'Africa';

SELECT SUM(population_years.population) AS 'Total',population_years.year,countries.continent FROM population_years CROSS JOIN countries WHERE population_years.year = 2005 AND countries.continent = 'Oceania';


SELECT AVG(population_years.population) AS 'Average',population_years.year,countries.continent FROM population_years CROSS JOIN countries WHERE population_years.year = 2003 AND countries.continent = 'South Amercia';

SELECT MIN(population_years.population),population_years.year,countries.name FROM population_years CROSS JOIN countries WHERE population_years.year = 2007;

This file has been truncated. show original

codeneutrino · October 14, 2020, 8:43pm

Hello @gouravjain07, welcome to the forums! The code looks good, and it looks like you’ve written it efficiently. One thing I would say is to break each clause up a bit. What I mean is instead of writing SELECT * FROM countries WHERE name = 'Africa';, you could write something like:

SELECT *
FROM countries
WHERE name = 'Africa';

This just helps readability. Other than that, I think your code looked good!

gouravjain07 · October 15, 2020, 2:11pm

Oh! Thanks will heed your suggestion