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: https://www.youtube.com/playlist?list=PLg_hSLs-7hbsJjC8r3SWcZmXWZakdgH88
PySpark Basic to Advance: https://www.youtube.com/playlist?list=PLg_hSLs-7hbvIqzZgvViJcxkW09yOwg3L
Resume Building and Interview Preps: https://youtu.be/ShhBumXLGbE
***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:
https://www.linkedin.com/company/data... 🔥
https://www.linkedin.com/company/data... 🔥
#sql #postgresql #deloitte #deloittejobs #capgeminihiring #cognizant #infosys #tcs #genpactjobs #mysql #interview #dataengineering #dataanalytics #dataanalysis #capgemini #capgeminijobs #sqlfordataengineer #jobinterview #coding #programming #technicalinterview