Spotify Interview problem solved using SQL | US Tracks Dominance

In this video we will discuss an interesting and cool advanced analytics problem asked in a Spotify. In this problem we have to find number of days a US track has stayed in the 1st position for both the US and worldwide rankings on the same day. Link to the dataset https://github.com/Hitesh-Damani/datascience_interviews_dataset/blob/6f22afa9fd083a8657afb3ddcbd7b5edd3eaa930/spotify_worldwide_daily_song_ranking.csv https://github.com/Hitesh-Damani/datascience_interviews_dataset/blob/6f22afa9fd083a8657afb3ddcbd7b5edd3eaa930/spotify_daily_rankings_2017_us.csv Link to Python Solution https://www.youtube.com/watch?v=FRCPv5makmc -------------------------------------------------------------------------------------------------- Support me by subscribing to my channel so that I can upload these kind of videos https://www.youtube.com/@hiteshdamani30 #sql #dataanalysts #datascienceinterview #sqlinterviewquestions #ai #sqlfordatascience #sqlforbeginners #dataengineers #spotifyinterview