Table 1: dates
******** ***** **** 01/01/2019 ** 12/31/2025.
***_**** | ***_**** ----------+---------- **** | ******** ***** | ******** **** | ****
Question 195
MoM user growth
Premium Access
Unlock this Snap 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
- **** ** * ******-** ******** ** #194
- ***** * ***** ** ****** *****-****-***** ****** **** ****** **** ***** 2021 ** ***** 2022 (*** ******* *** ***** ******** ** ***** 1, 2021)
- ***: ******* ****** ****. * **** **** ** ***** *** ***** **** *** ****_******* *****.
- *******: *** ******: (*******_*****_*** - ****_*****_***) *100.0 / ****_*****_***
Table 2: snap_session
***_**** | ***_**** ----------------+-------------------------- ****_** | ****** ***** | **** ** | **** -- **** ** *** *****
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.