report contiguous dates | google sql interview questions and answers |

report contiguous dates
google sql interview questions and answers
coding ninjas
Create Table Statement :
====================
Create table If Not Exists Failed
(
fail_date date
);
Create table If Not Exists Succeeded
(
success_date date
);
insert into Failed (fail_date)
values ('2018-12-28')
,('2018-12-29')
,('2019-01-04')
,('2019-01-05');
insert into Succeeded (success_date) values ('2018-12-30'),
('2018-12-31'),
('2019-01-01'),
('2019-01-02'),
('2019-01-03'),
('2019-01-06');
select *
from failed ;
select *
from succeeded ;
Need Help ? Connect With me 1:1 - topmate.io/dew...
Let's connect on LinkedIn : / dhirajgupta141
top interview question and answer in pyspark :
• top interview question...
PySpark Installation and Setup : • Spark Installation | P...
DSA In Python Interview Series : • dsa for data engineer ...
PySpark Interview Series : • pyspark interview ques...
Pandas Interview Series : • pandas interview quest...
SQL Interview Series : • sql interview question...
#google #codingninjas #sql #dataengineers #pivot #zs #fang #pyspark #sql #interview #dataengineers #dataanalytics #datascience #StrataScratch #Facebook #data #dataengineeringinterview #codechallenge #datascientist #pyspark #CodingInterview
#dsafordataguy #dewithdhairy #DEwithDhairy #dhiarjgupta #leetcode #topinterviewquestion