Data Analyst Spotify Case Study | SQL Interview Questions

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

• #science_technology
• #sql
• #sql_interview_questions
• #amazon_interview_questions
• #sql_interview_questions_and_answers
• #spotify_case_study
• #sql_case_study
• #master_sql