Table: session_web_duration
*** ****** ** ******* * **** ****** ** *******.
***_**** | ***_**** -----------------+--------------------- **** | **** *******_** | ****** ******** | ***
Question 103
Median and average session duration by day of the week
Premium Access
Unlock this Google interview question.
Sign in or upgrade to practice this question with full datasets, official solutions, and guided walkthroughs.
- 230+ interview questions
- Official solutions
- SQL, Python, and R tracks
- ***** * ***** ** ****** ***
*************** ******* ********, ** *** ** *** ****. - *** ******** ******** ** *** *** ** **** **
*******(*** **** ****) - *** **********, ** *** ****** ** ******* ***** ****** ******** ****.
- (********)*** *** *** **********_****(0.5) ****** *****(***** ** ***) ********* ******** ** ******* *** ******.
- (*****) ***** ** ** *****-** ****** ******** ** *****, *** *** **** **** ******** ** ***** **** ******** ** *** *****.
Sample results
Last Submission
postgresNo submission yet for this engine. Run and submit your query to save it here.
Copied
Expected results
Submit a query to compare against expected output.
Interview timer
Recommended interview pacing
Easy: 5 min for direct warm-up style questions.
Medium: 10 min for multi-step interview queries.
Hard: 15 min for layered questions with tighter time pressure.
A common bar is solving about 2 medium-or-harder questions in a 30 minute interview.
10:00
Your results
Run your query to preview results here.