SQL Case · Medium · 30 min
Mobile engagement: Split each device_user's events when inactivity exceeds 30 minutes
Mobile engagement: Split each deviceuser's events when inactivity exceeds 30 minutes.
View taskPublic task directory
Technical interview practice tasks
Every entry below is a crawlable link to a unique public task page. This directory complements the interactive filters and keeps the complete catalog connected through standard pagination.
Page 360 of 386 · 18,491 tasks
SQL Case · Easy · 20 min
Mobile engagement: Produce one status summary row per device_user
Mobile engagement: Produce one status summary row per deviceuser.
View taskSQL Case · Medium · 30 min
Mobile engagement: Find the feature with the largest completed value in each category
Mobile engagement: Find the feature with the largest completed value in each category.
View taskSQL Case · Medium · 30 min
Mobile engagement: Return the two highest-value device_users in each segment
Mobile engagement: Return the two highest-value deviceusers in each segment.
View taskSQL Case · Easy · 20 min
Mobile engagement: List device_users that never produced a goal_completed event
Mobile engagement: List deviceusers that never produced a goalcompleted event.
View taskSQL Case · Hard · 45 min
Search quality: Find completed events whose amount exceeds their searcher segment's completed-event average
Search quality: Find completed events whose amount exceeds their searcher segment's completed-event average.
View taskSQL Case · Medium · 30 min
Search quality: Find searchers that reached result_clicked no more than seven days after creation
Search quality: Find searchers that reached resultclicked no more than seven days after creation.
View taskSQL Case · Medium · 30 min
Search quality: Return searcher-result_set relationships active ten days after the first relationship began
Search quality: Return searcher-resultset relationships active ten days after the first relationship began.
View taskSQL Case · Easy · 20 min
Search quality: Find searchers with at least two recorded events
Search quality: Find searchers with at least two recorded events.
View taskSQL Case · Hard · 45 min
Search quality: Calculate each result_set category's share of all completed value
Search quality: Calculate each resultset category's share of all completed value.
View taskSQL Case · Easy · 20 min
Search quality: Calculate completed event value for each searcher segment
Search quality: Calculate completed event value for each searcher segment.
View taskSQL Case · Hard · 45 min
Search quality: Group consecutive active dates into islands for each searcher
Search quality: Group consecutive active dates into islands for each searcher.
View taskSQL Case · Easy · 20 min
Search quality: Count distinct searchers with activity on each day
Search quality: Count distinct searchers with activity on each day.
View taskSQL Case · Medium · 30 min
Search quality: Calculate daily completed value and its running total
Search quality: Calculate daily completed value and its running total.
View taskSQL Case · Hard · 45 min
Search quality: Measure whether each creation-date cohort returned on the next calendar day
Search quality: Measure whether each creation-date cohort returned on the next calendar day.
View taskSQL Case · Medium · 30 min
Search quality: Keep the latest row for each external event key
Search quality: Keep the latest row for each external event key.
View taskSQL Case · Easy · 20 min
Search quality: Find searchers with no activity after the first active month's end
Search quality: Find searchers with no activity after the first active month's end.
View taskSQL Case · Medium · 30 min
Search quality: Find completed events above the same searcher's completed-event average
Search quality: Find completed events above the same searcher's completed-event average.
View taskSQL Case · Easy · 20 min
Search quality: Return the first result_clicked timestamp for each searcher that succeeded
Search quality: Return the first resultclicked timestamp for each searcher that succeeded.
View taskSQL Case · Easy · 20 min
Search quality: Find events whose result_set reference does not exist
Search quality: Find events whose resultset reference does not exist.
View taskSQL Case · Easy · 20 min
Search quality: Return the latest event for each searcher
Search quality: Return the latest event for each searcher.
View taskSQL Case · Hard · 45 min
Search quality: Return one row per searcher with completed lifetime value and latest completed event
Search quality: Return one row per searcher with completed lifetime value and latest completed event.
View taskSQL Case · Easy · 20 min
Search quality: Combine live and archived completed events without accidental deduplication
Search quality: Combine live and archived completed events without accidental deduplication.
View taskSQL Case · Medium · 30 min
Search quality: Compare completed value with the previous active month
Search quality: Compare completed value with the previous active month.
View taskSQL Case · Medium · 30 min
Search quality: Calculate the completed-event rate for every result_set with activity
Search quality: Calculate the completed-event rate for every resultset with activity.
View taskSQL Case · Hard · 45 min
Search quality: Resolve every result_set to its root result_set
Search quality: Resolve every resultset to its root resultset.
View taskSQL Case · Medium · 30 min
Search quality: Count searchers that produced query_issued and later produced result_clicked
Search quality: Count searchers that produced queryissued and later produced resultclicked.
View taskSQL Case · Medium · 30 min
Search quality: Rank searchers by completed amount inside each region
Search quality: Rank searchers by completed amount inside each region.
View taskSQL Case · Medium · 30 min
Search quality: Find result_clicked events that happened within seven days of the same searcher's previous success
Search quality: Find resultclicked events that happened within seven days of the same searcher's previous success.
View taskSQL Case · Hard · 45 min
Search quality: Calculate the rolling average over each searcher's current and previous two events
Search quality: Calculate the rolling average over each searcher's current and previous two events.
View taskSQL Case · Medium · 30 min
Search quality: Measure the share of searchers in each segment that ever reached result_clicked
Search quality: Measure the share of searchers in each segment that ever reached resultclicked.
View taskSQL Case · Medium · 30 min
Search quality: Split each searcher's events when inactivity exceeds 30 minutes
Search quality: Split each searcher's events when inactivity exceeds 30 minutes.
View taskSQL Case · Easy · 20 min
Search quality: Produce one status summary row per searcher
Search quality: Produce one status summary row per searcher.
View taskSQL Case · Medium · 30 min
Search quality: Find the result_set with the largest completed value in each category
Search quality: Find the resultset with the largest completed value in each category.
View taskSQL Case · Medium · 30 min
Search quality: Return the two highest-value searchers in each segment
Search quality: Return the two highest-value searchers in each segment.
View taskSQL Case · Easy · 20 min
Search quality: List searchers that never produced a result_clicked event
Search quality: List searchers that never produced a resultclicked event.
View taskSQL Case · Hard · 45 min
Security operations: Find completed events whose amount exceeds their identity segment's completed-event average
Security operations: Find completed events whose amount exceeds their identity segment's completed-event average.
View taskSQL Case · Medium · 30 min
Security operations: Find identitys that reached challenge_passed no more than seven days after creation
Security operations: Find identitys that reached challengepassed no more than seven days after creation.
View taskSQL Case · Medium · 30 min
Security operations: Return identity-asset relationships active ten days after the first relationship began
Security operations: Return identity-asset relationships active ten days after the first relationship began.
View taskSQL Case · Easy · 20 min
Security operations: Find identitys with at least two recorded events
Security operations: Find identitys with at least two recorded events.
View taskSQL Case · Hard · 45 min
Security operations: Calculate each asset category's share of all completed value
Security operations: Calculate each asset category's share of all completed value.
View taskSQL Case · Easy · 20 min
Security operations: Calculate completed event value for each identity segment
Security operations: Calculate completed event value for each identity segment.
View taskSQL Case · Hard · 45 min
Security operations: Group consecutive active dates into islands for each identity
Security operations: Group consecutive active dates into islands for each identity.
View taskSQL Case · Easy · 20 min
Security operations: Count distinct identitys with activity on each day
Security operations: Count distinct identitys with activity on each day.
View taskSQL Case · Medium · 30 min
Security operations: Calculate daily completed value and its running total
Security operations: Calculate daily completed value and its running total.
View taskSQL Case · Hard · 45 min
Security operations: Measure whether each creation-date cohort returned on the next calendar day
Security operations: Measure whether each creation-date cohort returned on the next calendar day.
View taskSQL Case · Medium · 30 min
Security operations: Keep the latest row for each external event key
Security operations: Keep the latest row for each external event key.
View taskSQL Case · Easy · 20 min
Security operations: Find identitys with no activity after the first active month's end
Security operations: Find identitys with no activity after the first active month's end.
View task