Youtor
Data Analyst Spotify Case Study SQL Interview Questions
>> YOUR LINK HERE: ___ http://youtube.com/watch?v=-YdAIMjHZrM
In this video we will discuss a Spotify case study. This case study has 5 questions and with each question difficulty level will go up. • Video Content: • 00:00 Understand the problem statement • 01:52 Daily active users • 03:31 Weekly active users • 04:39 same day install and purchase • 09:10 country wise paid users • 15:11 Last question and assignment • Most Asked Join Based Interview Question: • • Most Asked SQL JOIN based Interview Q... • Top 10 SQL interview Questions: • • Top 10 SQL interview Questions and An... • Interview Question based on FULL OUTER JOIN: • • SQL Interview Question Based on Full ... • Playlist to master SQL : • • Complex SQL Questions for Interview P... • Rand, Dense_Rank and Row_Number: • • RANK, DENSE_RANK, ROW_NUMBER SQL Anal... • Script to create and insert data: • CREATE table activity • ( • user_id varchar(20), • event_name varchar(20), • event_date date, • country varchar(20) • ); • delete from activity; • insert into activity values (1,'app-installed','2022-01-01','India') • ,(1,'app-purchase','2022-01-02','India') • ,(2,'app-installed','2022-01-01','USA') • ,(3,'app-installed','2022-01-01','USA') • ,(3,'app-purchase','2022-01-03','USA') • ,(4,'app-installed','2022-01-03','India') • ,(4,'app-purchase','2022-01-03','India') • ,(5,'app-installed','2022-01-03','SL') • ,(5,'app-purchase','2022-01-03','SL') • ,(6,'app-installed','2022-01-04','Pakistan') • ,(6,'app-purchase','2022-01-04','Pakistan'); • • #sql #dataanalyst #spotify #casestudy
#############################
