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

Опубликовано: 16 Октябрь 2024
на канале: Data Project Hub

214

In this video we will solve a complex sql interview question.

🔍 Looking for something specific? Check out my curated playlists.

✅Complex SQL Interview Questions
   • Complex SQL Interview Questions: Mast...

✅SQL Interview Questions
   • SQL Interview Bootcamp: Questions & P...

✅SQL Mastery Interview Prep
   • SQL Concepts: Detailed Interview Ques...

✅Learn SQL Concepts
   • SQL Fundamentals: Key Concepts and Sk...

✅SQL Functions
   • SQL Functions Explained: Practical Us...

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!" 🚀