课程: Coding Exercises: SQL Data Science

今天就学习课程吧！

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

Removing duplicate data

Removing duplicate data - SQL教程

课程: Coding Exercises: SQL Data Science

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

Removing duplicate data

“

- [Instructor] It is just another day at the office. And this time, Tom, who is the social media strategist at your firm has reached out to you. He wants to look at the data when social media posts received the most number of new likes, but he is facing an error. As there are multiple duplicate entries in the database, he is requesting you to get him the cleaned unique rows. Now, this translates into a challenge where you are required to get unique rows for the days when the posts received the most number of new likes from the table GlobalPage. Now to break it down further, you might want to use DISTINCT function to get rid of the duplicate rows. Then, you need to create date column, and the new_likes column from the table GlobalPage. Lastly, as per Tom's request, he wants to look at the days with the most number of new likes. So sort the data by new_likes in the descending order. Now, try to write the sequel query to…

内容