Deloitte SQL Interview Question 2024 | Cases that reached each stage of completion for each center

In this video, I have discussed how to solve the SQL Interview Questions: "How many cases have reached each stage of completion (Stage 1 to Stage 5) for each center?" -- Query to create table: CREATE TABLE CaseProgress ( Center_ID VARCHAR(10), Case_ID INT, Stage1 DATE, Stage2 DATE, Stage3 DATE, Stage4 DATE, Stage5 DATE ); -- Insert data INSERT INTO CaseProgress (Center_ID, Case_ID, Stage1, Stage2, Stage3, Stage4, Stage5) VALUES ('C1', 1, '2024-01-01', NULL, NULL, '2024-01-13', NULL), ('C1', 2, '2024-01-05', '2024-01-10', NULL, NULL, NULL), ('C2', 3, NULL, '2024-01-10', NULL, NULL, '2024-01-20'), ('C3', 4, '2024-01-05', '2024-01-12', '2024-01-12', '2024-01-14', '2024-01-20'), ('C3', 5, '2024-01-10', '2024-01-15', NULL, NULL, NULL), ('C3', 6, NULL, NULL, NULL, '2024-01-15', NULL); SQL Interview QnAs Asked in different Companies:    • SQL Interview Questions Asked in Different...   PySpark Basic to Advance:    • PySpark Tutorial   Resume Building and Interview Preps:    • Resume Building and Interview Preps   ***Join our Telegram Group for regular updates on Jobs and Data Science materials: https://t.me/datasciencecorner 🔥 https://t.me/datasciencecorner 🔥 Instagram: https://bit.ly/3LKnSmw 🔥 https://bit.ly/3LKnSmw 🔥 LinkedIn:   / data.  . 🔥   / data.  . 🔥 #sql #postgresql #deloitte #deloittejobs #capgeminihiring #cognizant #infosys #tcs #genpactjobs #mysql #interview #dataengineering #dataanalytics #dataanalysis #capgemini #capgeminijobs #sqlfordataengineer #jobinterview #coding #programming #technicalinterview