105. Number of days gap between last two actions

hard google

  • ************************************************************************************************
  • *****************************************************************************1
  • *********************************************************0
  • *****************************************************************
  • *****************************************************************

Table: session_web

**************************************************************************************************


*****************************************************************************************************************************************************************************************

Sample results




Last Submission postgres

Expected results


More Google questions

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