Deloitte and Flipkart SQL Interview Question (Medium Level) | Confirmation of signups💡

In this video, we will solve the SQL Medium Level interview question asked in Deloitte and Flipkart. SQL Script: CREATE TABLE Signups ( user_id INT PRIMARY KEY, time_stamp DATETIME ); INSERT INTO Signups (user_id, time_stamp) VALUES (3, '2020-03-21 10:16:13'), (7, '2020-01-04 13:57:59'), (2, '2020-07-29 23:09:44'), (6, '2020-12-09 10:39:37'); CREATE TABLE Confirmations ( user_id INT, time_stamp DATETIME, action VARCHAR(10) CHECK (action IN ('confirmed', 'timeout')), PRIMARY KEY (user_id, time_stamp), FOREIGN KEY (user_id) REFERENCES Signups(user_id) ); INSERT INTO Confirmations (user_id, time_stamp, action) VALUES (3, '2021-01-06 03:30:46', 'timeout'), (3, '2021-07-14 14:00:00', 'timeout'), (7, '2021-06-12 11:57:29', 'confirmed'), (7, '2021-06-13 12:58:28', 'confirmed'), (7, '2021-06-14 13:59:27', 'confirmed'), (2, '2021-01-22 00:00:00', 'confirmed'), (2, '2021-02-28 23:59:59', 'timeout'); Easy - Level questions - https://youtube.com/playlist?list=PLP8zk3fCtbPIRr92ZlRnw6H__IgWQdetg&si=-HgJ2ZeVg1IL35f3 Medium - Level questions - https://youtube.com/playlist?list=PLP8zk3fCtbPI6zpFi9-BENOuzCtUpMUwe&si=O1m4aK2fupBozHNt Hard-Level SQL interview questions - https://youtube.com/playlist?list=PLP8zk3fCtbPK-D8N_jInxlPNaDdlwEjHJ&si=gHH5avPPSunyM6Jx If you have any interesting SQL questions, feel free to send them to me at [email protected]. #sqlserver #dataanalytics #dataanalyst #sqlqueries #sqlqueryinterviewquestionsandanswers #data #sql #sqldeveloper #faangpreparation #deloitte #flipkart #sqlqueries