MENU

Fun & Interesting

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

Data Science Corner 10,623 lượt xem 5 months ago
Video Not Working? Fix It Now

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

Comment