Airbnb SQL Interview Question | Convert Comma Separated Values into Rows | Data Analytics
In this video we are going to discuss a SQL problem asked in Airbnb interview. The problem is called as Most Popular Room Types. In this problem we will learn how to convert comma separated values into row.
Zero to hero(Advance) SQL Aggregation:
• All About SQL Aggregations | SQL Adva...
Most Asked Join Based Interview Question:
• Most Asked SQL JOIN based Interview Q...
Solving 4 Trick SQL problems:
• Solving 4 Tricky SQL Problems
Data Analyst Spotify Case Study:
• Data Analyst Spotify Case Study | SQL...
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...
Rank, Dense_Rank and Row_Number:
• RANK, DENSE_RANK, ROW_NUMBER SQL Anal...
script:
create table airbnb_searches
(
user_id int,
date_searched date,
filter_room_types varchar(200)
);
delete from airbnb_searches;
insert into airbnb_searches values
(1,'2022-01-01','entire home,private room')
,(2,'2022-01-02','entire home,shared room')
,(3,'2022-01-02','private room,shared room')
,(4,'2022-01-03','private room')
;
#sql #airbnb #interview