Скачать с ютуб Display consecutive days for which conditions are satisfied | Tricky SQL Interview Question в хорошем качестве

Display consecutive days for which conditions are satisfied | Tricky SQL Interview Question

In this video we discuss a query which deal with finding consecutive days for which some conditions are met. This is a very commonly asked interview questions and the concept used in the video can be used to solve similar queries. DDL for table and DML for the tables used are given below: --table stadium --table creating create table stadium( id int, visit_date date, people int ) --insert data into table stadium insert into stadium(id,visit_date,people) values(1,'2022-01-01',10), (2,'2022-01-02',109), (3,'2022-01-03',150), (4,'2022-01-04',99), (5,'2022-01-05',150), (6,'2022-01-06',145), (7,'2022-01-07',199), (8,'2022-01-08',188), (9,'2022-01-09',99), (10,'2022-01-10',109), (11,'2022-01-11',150), (12,'2022-01-12',100), (13,'2022-01-13',89), (14,'2022-01-14',121), (15,'2022-01-15',145) #dataprojecthub #data_project_hub #sqlqueries #sqlinterviewquestions #dataanalytics