Table 1: snap_account
***** ****** *****.
***_**** | ***_**** ----------------+-------------------------- ****_** | ****** ******_** | ****
Question 196
User segments report
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
***** * ***** ** ****** *** ****** ** ***** ** *** ********* *******.
******** ***** ** 2021-04-01.
- ***: ***** **** **** ****** ** ** 2021-04-01
- *******: ****** ** ****** 2021-03-18, *** *** ****** *** *** **** 14 ****: 2021-03-18 - 2021-03-31 (***********);
- ***********: ******* *** *** ****** 2021-04-01 *** ****** ****** *****(2021-04-01)
- ********: ****** ***** *** *** ***********.
Table 2: snap_dau
**** ** ****** ***** *** ***** **** **** *** ******.
***_**** | ***_**** ----------------+-------------------------- ****_** | ****** ******_** | ****
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.