Tricky SQL Interview Question | Calculate Average User Session Time | Data Analyst Interview

In this video we will solve a complex sql interview question. 🔍 Looking for something specific? Check out my curated playlists. ✅Complex SQL Interview Questions https://youtube.com/playlist?list=PLRj6ORzjeGQ6u-Jz--t7PTmXSDxfjJWTa&si=nvtIcMCSfJ6CO1j4 ✅SQL Interview Questions https://youtube.com/playlist?list=PLRj6ORzjeGQ531TsgG_twzlY0796sVq1Z&si=XYHZav9zsrvPt7KW ✅SQL Mastery Interview Prep https://youtube.com/playlist?list=PLRj6ORzjeGQ4MBIHa3eebU40TEtL2Exro&si=PHRpwYZkboyzRrtI ✅Learn SQL Concepts https://youtube.com/playlist?list=PLRj6ORzjeGQ78O-MPcTWJuqaPUon_y2Ng&si=AazoKYf9kCwVFO-w ✅SQL Functions https://youtube.com/playlist?list=PLRj6ORzjeGQ43ut0YIOPYoyr35ez0_9dd&si=WBWxVw-_KGlhhokK Don't forget to hit the subscribe button and ring the notification bell to never miss an update! Become a valued member of our passionate community and be part of the journey with me! Table Script : create table users_web_log( user_id int, timestamp datetime, action varchar(25) ) insert into users_web_log(user_id,timestamp,action) values(0 ,'2023-04-25 13:30:15','page_load'), (0 ,'2023-04-25 13:30:18','page_load'), (0 ,'2023-04-25 13:30:40','scroll_down'), (0 ,'2023-04-25 13:30:45','scroll_up'), (0 ,'2023-04-25 13:31:10','scroll_down'), (0 ,'2023-04-25 13:31:25','scroll_down'), (0 ,'2023-04-25 13:31:40','page_exit'), (1 ,'2023-04-25 13:40:00','page_load'), (1 ,'2023-04-25 13:40:10','scroll_down'), (1 ,'2023-04-25 13:40:15','scroll_down'), (1 ,'2023-04-25 13:40:20','scroll_down'), (1 ,'2023-04-25 13:40:25','scroll_down'), (1 ,'2023-04-25 13:40:30','scroll_down'), (1 ,'2023-04-25 13:40:35','page_exit'), (2 ,'2023-04-25 13:41:21','page_load'), (2 ,'2023-04-25 13:41:30','scroll_down'), (2 ,'2023-04-25 13:41:35','scroll_down'), (2 ,'2023-04-25 13:41:40','scroll_up'), (1 ,'2023-04-26 11:15:00','page_load'), (1 ,'2023-04-26 11:15:10','scroll_down'), (1 ,'2023-04-26 11:15:20','scroll_down'), (1 ,'2023-04-26 11:15:25','scroll_up'), (1 ,'2023-04-26 11:15:35','page_exit'), (0 ,'2023-04-28 14:30:15','page_load'), (0 ,'2023-04-28 14:30:10','page_load'), (0 ,'2023-04-28 13:30:40','scroll_down'), (0 ,'2023-04-28 15:31:40','page_exit') Thanks for watching, and see you in the next video!" 🚀