For each user, find the number of days gap between their last action and the second last action. e.g., if the last 2 actions are on '2021-08-01' and '2021-08-02', the gap is 1 If the last 2 actions happen on the same day, the gap is 0 Definition of action:&nb…

Prev Discuss

Question 105

Number of days gap between last two actions

Unsolved Hard google Lecture

Premium Access

Unlock this Google interview question.

230+ interview questions
Official solutions
SQL, Python, and R tracks

*** **** ****, **** *** ****** ** **** *** ******* ***** **** ****** *** *** ****** **** ******.
*.*., ** *** **** 2 ******* *** ** '2021-08-01' *** '2021-08-02', *** *** ** 1
** *** **** 2 ******* ****** ** *** **** ***, *** *** ** 0
********** ** ******: *** ***** **** ** *** ** ***** *** ** ****.
** * **** *** ** ******, ** ***** **** 2 *******, **** **** ****.

Table: session_web

***** **** * **** ****** *** *******, * *** ******* ******, ** **** **** *** **** ****** *** ****.

  ***_****       | ***_****
-----------------+---------------------
****             | ****    
****_**          | ******
*******_**       | ******
*****            | *******(20)

Sample results

Last Submission

postgres

No submission yet for this engine. Run and submit your query to save it here.

Expected results

Submit a query to compare against expected output.

Engine

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

Timer

Your results

Run your query to preview results here.

More Google Questions

Browse Company Set

Question	Level	FTPR
#101. Average number of visits per user	Easy	14%
#102. Histogram by visit session duration	Hard	17%
#103. Median and average session duration by day of the week	Medium	20%
#104. MAU: Monthly active users	Easy	20%
#106. Mobile vs. web	Medium	10%
#107. Customer count by platform	Medium	17%
#147. 2 days streak customers	Hard	13%
#148. Most popular video category	Medium	13%
#149. fans by video category	Easy	36%
#150. Countries with above average customers	Easy	15%
#186. Average comments per question	Easy	10%
#187. Comment distribution at Google Forum	Easy	17%
#188. Top 1 popular question by department	Hard	14%