课程: Coding Exercises: SQL Data Science

今天就学习课程吧！

今天就开通帐号，24,700 门业界名师课程任您挑！

Outer and cross joins

Outer and cross joins - SQL教程

课程: Coding Exercises: SQL Data Science

开始一个月试用 购买团队方案

Outer and cross joins

“

(video game tune) - [Instructor] Diving deeper into the analysis, the growth team also wants to study the countries that have large population, but still lowest number of fans. Karl has reached out again, and this time he wants to look at the bottom 10 countries that have lowest number of fans, but have large population. Now, this translates into a challenge where you have to first define and quantify large population. So you decided that you will only look for countries that have population equal to or greater than 20 million. And in these countries, you have to first find out the countries that have the smallest number of fans. Again, we'll need to join the two tables: fans per country, and the population is going to come from PopStats. You need to extract the data for the latest date, which is 2018-10-16. Then you will order the data by number of fans, because we need to look at the bottom 10 countries. So this…

内容