Airbnb SQL Interview Problem | Converted Comma Separated Values into Rows

Опубликовано: 25 Апрель 2023
на канале: Kraminka Verma.

In this video we will solve Airbnb SQL Problem and we will learn how to convert comma separated value into rows.

1.SQL Interview Questions
   • Query To Find Maximum, Minimum and Av...

2.SQL Basic

   • Introduction to Structured Query Lang...

3.SQL Advance Concept

   • VIEWS IN SQL || WHY WE USE VIEWS IN S...

4. Tableau
   • Funnel chart in Tableau || Tableau Tu...

5. Python Tutorial
https://lnkd.in/dEcjgjSw

script:
create table airbnb_searches
(
user_id int,
date_searched date,
filter_room_types varchar(150)
);

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')
;