Table 1: session_web
***** **** * **** ****** *** *******, * *** ******* ******, ** **** **** *** **** ****** *** ****.
***_**** | ***_**** -----------------+--------------------- **** | **** ****_** | ****** *******_** | ****** ***** | *******(20)
Question 102
Histogram by visit session duration
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
- ***** * ***** ** ******** *** ************ ** *** ****** ** ***** ** ********* ******* *********.
- *** **********, ** **** ** **** *** ********* **** ********* *** *** ***** ******.
- **** **** 50 *******. *****:
< 50 - [50, 100) *******. *****:
50, 100 - [100, 150) *******. *****:
100, 150 - [150, 200) *******. *****:
150, 200 - [200, 250) *******. *****:
200, 250 - 250 ******* *** *****. *****:
>= 250
- **** **** 50 *******. *****:
- * **** *** **** ******** ******** **** ********* ******** *** *** ** ******* ******** *****.
Table 2: session_web_duration
*** ****** ** ******* * **** ****** ** *******.
***_**** | ***_**** -----------------+--------------------- **** | **** *******_** | ****** ******** | ***
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.
15:00
Your results
Run your query to preview results here.