Question 104
Premium Access
Sign in or upgrade to practice this question with full datasets, official solutions, and guided walkthroughs.
** * **** *** ** ***** *** ***-*****, ** ***-**** ***** (*.*., ***) ** ****** *** ** ******.Table 1: session_mobile
***** **** * **** ***** *** ****** *** (***, *******), * *** ******* ******, ** **** **** *** **** ****** *** ***.
***_**** | ***_**** -----------------+--------------------- **** | **** ****_** | ****** *******_** | ****** ***** | *******(20)
Table 2: session_web
***** **** * **** ****** *** *******, * *** ******* ******, ** **** **** *** **** ****** *** ****.
***_**** | ***_**** -----------------+--------------------- **** | **** ****_** | ****** *******_** | ****** ***** | *******(20)
Sample results
Last Submission
postgresNo submission yet for this engine. Run and submit your query to save it here.
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.
5:00
Run your query to preview results here.