DELOITTE SQL INTERVIEW QUESTION? | Logs data

Join this channel to get access to perks: https://www.youtube.com/channel/UCTcOXx-NtZswf_yoRZCw7NA/join Feedback: https://forms.gle/NQuCAy7p5a9wxW3LA DROP TABLE IF EXISTS dbo.Logs CREATE TABLE Logs ( [ID] INT, [OccurenceTime] DATETIME, [Message] NVARCHAR(MAX) ) INSERT INTO Logs VALUES (1,'2024-01-12 10:00:00','Pass'), (1,'2024-01-12 15:00:00','Fail'), (1,'2024-01-13 10:00:00','In-Progress'), (1,'2024-01-13 05:00:00','Pass'), (2,'2024-01-12 08:30:00','Pass'), (2,'2024-01-13 08:30:00','Fail'), (2,'2024-01-14 10:00:00','Fail') SELECT * FROM Logs PBIX: https://github.com/datasculptor2895/DataSculptor/blob/main/Logs.pbix Playlists: SQL Interview Questions: https://www.youtube.com/playlist?list=PLNlYnu7poveKW915P7Yafz3mNqnIefh3e Recursive CTE: https://www.youtube.com/playlist?list=PLNlYnu7poveK0ySrsIgUihCCryXo-KQj6 PySpark Interview Questions: https://www.youtube.com/playlist?list=PLNlYnu7poveI0umHioVrs6yI6ruP2wy5M Power BI and DAX: https://www.youtube.com/playlist?list=PLNlYnu7poveIK-Fjk7j9xE_9k9tlWFnEE Data Modeling: https://www.youtube.com/playlist?list=PLNlYnu7poveKKEKmJBbvTfyazt6aUiGCw Generative AIs: https://www.youtube.com/playlist?list=PLNlYnu7poveJ6F2xspS7nOZqDV0-G-cmd Excel: https://www.youtube.com/playlist?list=PLNlYnu7poveKW8q_NFOOEew8xA44Y_4kt Cricket: https://www.youtube.com/playlist?list=PLNlYnu7poveJ7pXb00jftk5yoTtuoQjaY SQL ADVANCED AGGREGATIONS: https://www.youtube.com/playlist?list=PLNlYnu7poveJ0ei855_X_gy_ZEj_z4vz1 Follow me Linkedin: https://www.linkedin.com/in/data-sculptor-93a00b2a8 Instagram: https://www.instagram.com/datasculptor2895