In this video we will be solving very interesting problem which was asked in the "PwC interview" in SQL.


"pwc question and answer" in sql
"sql question and answer"


Create table Statement :
====================
CREATE TABLE pwc_attandance_log (
emp_id INT,
log_date DATE,
flag CHAR
);
insert into pwc_attandance_log(emp_id,log_date,flag) values
(101,'02012024','N'),
(101,'03012024','Y'),
(101,'04012024','N'),
(101,'07012024','Y'),
(102,'01012024','N'),
(102,'02012024','Y'),
(102,'03012024','Y'),
(102,'04012024','N'),
(102,'05012024','Y'),
(102,'06012024','Y'),
(102,'07012024','Y'),
(103,'01012024','N'),
(103,'04012024','N'),
(103,'05012024','Y'),
(103,'06012024','Y'),
(103,'07012024','N');

PySpark Solution for this problem :    • pwc question and answer in pyspark | ...  

Need Help ? Connect With me 1:1 https://topmate.io/dewithdhairy

Let's connect on LinkedIn :   / dhirajgupta141  


PySpark Installation and Setup :    • Spark Installation | PySpark Installa...  


DSA In Python Interview Series :    • dsa for data engineer | dsa for data ...  


PySpark Interview Series :    • pyspark interview questions and answers  


Pandas Interview Series :    • pandas interview questions and answers  


SQL Interview Series :    • sql interview questions and answers  








#pwc #pyspark #sql #interview #dataengineers #dataanalytics #datascience #StrataScratch #Facebook #data #dataengineeringinterview #codechallenge #datascientist #pyspark #CodingInterview
#dsafordataguy #dewithdhairy #DEwithDhairy #dhiarjgupta #leetcode #topinterviewquestion