Amazon Data Engineer SQL Interview Problem | Leetcode Hard SQL 2494 | Recursive CTE
Автор: Ankit Bansal
Загружено: 2023-04-08
Просмотров: 23149
Описание:
In this video we are going to discuss leetcode hard SQL problem 2494. It was asked in Amazon for Data Engineer position as well.
Master the ART of SQL :
https://www.namastesql.com/
Ready script:
create table hall_events
(
hall_id integer,
start_date date,
end_date date
);
delete from hall_events
insert into hall_events values
(1,'2023-01-13','2023-01-14')
,(1,'2023-01-14','2023-01-17')
,(1,'2023-01-15','2023-01-17')
,(1,'2023-01-18','2023-01-25')
,(2,'2022-12-09','2022-12-23')
,(2,'2022-12-13','2022-12-17')
,(3,'2022-12-01','2023-01-30');
Zero to hero(Advance) SQL Aggregation:
• All About SQL Aggregations | SQL Advance |...
Most Asked Join Based Interview Question:
• Most Asked SQL JOIN based Interview Questi...
Solving 4 Trick SQL problems:
• Solving 4 Tricky SQL Problems
Data Analyst Spotify Case Study:
• Data Analyst Spotify Case Study | SQL Inte...
Top 10 SQL interview Questions:
• Top 10 SQL interview Questions and Answers...
Interview Question based on FULL OUTER JOIN:
• SQL Interview Question Based on Full Outer...
Playlist to master SQL :
• Complex SQL Questions for Interview Prepar...
Rank, Dense_Rank and Row_Number:
• RANK, DENSE_RANK, ROW_NUMBER SQL Analytica...
#sql #dataengineer
Повторяем попытку...
Доступные форматы для скачивания:
Скачать видео
-
Информация по загрузке:
