课程: Coding Exercises: SQL Data Science

今天就学习课程吧！

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

Set theory for SQL joins

Set theory for SQL joins - SQL教程

课程: Coding Exercises: SQL Data Science

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

Set theory for SQL joins

“

- [Instructor] It's been a hectic week, and Karl has reached out with another task. And he now wants you to dive into the cities where your organization has good reach with a large number of fans. He wants you to send him the top 10 cities with the largest number of fans. So the challenge is to find out the top 10 cities and their countries that have the largest number of fans. Now to break it down further, we'll have to join fans per city table with the pop stats table to get cities along with the countries that they are in. And then there are multiple rows for each date in the table. So you'll have to group by city and country to aggregate the total number of fans in each city. And then you'll have to order it by the aggregated number of fans and limit it to display only top 10 cities. Now with that said, you should now try to write the sequel query to solve this challenge. Again, pause the video. And once you…

内容