pwc question and answer in sql | top interview questions and answer in sql | #interview

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,'02-01-2024','N'), (101,'03-01-2024','Y'), (101,'04-01-2024','N'), (101,'07-01-2024','Y'), (102,'01-01-2024','N'), (102,'02-01-2024','Y'), (102,'03-01-2024','Y'), (102,'04-01-2024','N'), (102,'05-01-2024','Y'), (102,'06-01-2024','Y'), (102,'07-01-2024','Y'), (103,'01-01-2024','N'), (103,'04-01-2024','N'), (103,'05-01-2024','Y'), (103,'06-01-2024','Y'), (103,'07-01-2024','N'); PySpark Solution for this problem : https://youtu.be/13CgxtUAO8I Need Help ? Connect With me 1:1 - https://topmate.io/dewithdhairy Let's connect on LinkedIn : https://www.linkedin.com/in/dhirajgupta141/ PySpark Installation and Setup : https://youtu.be/jO9wZGEsPRo?si=WVktJl4eh0mN3P9X DSA In Python Interview Series : https://youtube.com/playlist?list=PLqGLh1jt697wQTamFvXx_Odlm-Wg3zbxq&si=CAiVdcY4A7CEOKlO PySpark Interview Series : https://youtube.com/playlist?list=PLqGLh1jt697zXpQy8WyyDr194qoCLNg_0&si=-JG6S1LyZzjDZyPB Pandas Interview Series : https://youtube.com/playlist?list=PLqGLh1jt697yabH8-hRdV8Y5nzIEHDo29&si=1bwfHNeKLvcUFFXX SQL Interview Series : https://youtube.com/playlist?list=PLqGLh1jt697xtgiGwGUTFpOctT82ANdJZ&si=fsF6PkJiStf9_Dh- #pwc #pyspark #sql #interview #dataengineers #dataanalytics #datascience #StrataScratch #Facebook #data #dataengineeringinterview #codechallenge #datascientist #pyspark #CodingInterview #dsafordataguy #dewithdhairy #DEwithDhairy #dhiarjgupta #leetcode #topinterviewquestion