Public 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 361 of 386 · 18,491 tasks

SQL Case · Medium · 30 min

Security operations: Find completed events above the same identity's completed-event average

Security operations: Find completed events above the same identity's completed-event average.

View task

SQL Case · Easy · 20 min

Security operations: Return the first challenge_passed timestamp for each identity that succeeded

Security operations: Return the first challengepassed timestamp for each identity that succeeded.

View task

SQL Case · Easy · 20 min

Security operations: Find events whose asset reference does not exist

Security operations: Find events whose asset reference does not exist.

View task

SQL Case · Easy · 20 min

Security operations: Return the latest event for each identity

Security operations: Return the latest event for each identity.

View task

SQL Case · Hard · 45 min

Security operations: Return one row per identity with completed lifetime value and latest completed event

Security operations: Return one row per identity with completed lifetime value and latest completed event.

View task

SQL Case · Easy · 20 min

Security operations: Combine live and archived completed events without accidental deduplication

Security operations: Combine live and archived completed events without accidental deduplication.

View task

SQL Case · Medium · 30 min

Security operations: Compare completed value with the previous active month

Security operations: Compare completed value with the previous active month.

View task

SQL Case · Medium · 30 min

Security operations: Calculate the completed-event rate for every asset with activity

Security operations: Calculate the completed-event rate for every asset with activity.

View task

SQL Case · Hard · 45 min

Security operations: Resolve every asset to its root asset

Security operations: Resolve every asset to its root asset.

View task

SQL Case · Medium · 30 min

Security operations: Count identitys that produced challenge_started and later produced challenge_passed

Security operations: Count identitys that produced challengestarted and later produced challengepassed.

View task

SQL Case · Medium · 30 min

Security operations: Rank identitys by completed amount inside each region

Security operations: Rank identitys by completed amount inside each region.

View task

SQL Case · Medium · 30 min

Security operations: Find challenge_passed events that happened within seven days of the same identity's previous success

Security operations: Find challengepassed events that happened within seven days of the same identity's previous success.

View task

SQL Case · Hard · 45 min

Security operations: Calculate the rolling average over each identity's current and previous two events

Security operations: Calculate the rolling average over each identity's current and previous two events.

View task

SQL Case · Medium · 30 min

Security operations: Measure the share of identitys in each segment that ever reached challenge_passed

Security operations: Measure the share of identitys in each segment that ever reached challengepassed.

View task

SQL Case · Medium · 30 min

Security operations: Split each identity's events when inactivity exceeds 30 minutes

Security operations: Split each identity's events when inactivity exceeds 30 minutes.

View task

SQL Case · Easy · 20 min

Security operations: Produce one status summary row per identity

Security operations: Produce one status summary row per identity.

View task

SQL Case · Medium · 30 min

Security operations: Find the asset with the largest completed value in each category

Security operations: Find the asset with the largest completed value in each category.

View task

SQL Case · Medium · 30 min

Security operations: Return the two highest-value identitys in each segment

Security operations: Return the two highest-value identitys in each segment.

View task

SQL Case · Easy · 20 min

Security operations: List identitys that never produced a challenge_passed event

Security operations: List identitys that never produced a challengepassed event.

View task

SQL Case · Hard · 45 min

Subscription lifecycle: Find completed events whose amount exceeds their account segment's completed-event average

Subscription lifecycle: Find completed events whose amount exceeds their account segment's completed-event average.

View task

SQL Case · Medium · 30 min

Subscription lifecycle: Find accounts that reached subscription_activated no more than seven days after creation

Subscription lifecycle: Find accounts that reached subscriptionactivated no more than seven days after creation.

View task

SQL Case · Medium · 30 min

Subscription lifecycle: Return account-plan relationships active ten days after the first relationship began

Subscription lifecycle: Return account-plan relationships active ten days after the first relationship began.

View task

SQL Case · Easy · 20 min

Subscription lifecycle: Find accounts with at least two recorded events

Subscription lifecycle: Find accounts with at least two recorded events.

View task

SQL Case · Hard · 45 min

Subscription lifecycle: Calculate each plan category's share of all completed value

Subscription lifecycle: Calculate each plan category's share of all completed value.

View task

SQL Case · Easy · 20 min

Subscription lifecycle: Calculate completed event value for each account segment

Subscription lifecycle: Calculate completed event value for each account segment.

View task

SQL Case · Hard · 45 min

Subscription lifecycle: Group consecutive active dates into islands for each account

Subscription lifecycle: Group consecutive active dates into islands for each account.

View task

SQL Case · Easy · 20 min

Subscription lifecycle: Count distinct accounts with activity on each day

Subscription lifecycle: Count distinct accounts with activity on each day.

View task

SQL Case · Medium · 30 min

Subscription lifecycle: Calculate daily completed value and its running total

Subscription lifecycle: Calculate daily completed value and its running total.

View task

SQL Case · Hard · 45 min

Subscription lifecycle: Measure whether each creation-date cohort returned on the next calendar day

Subscription lifecycle: Measure whether each creation-date cohort returned on the next calendar day.

View task

SQL Case · Medium · 30 min

Subscription lifecycle: Keep the latest row for each external event key

Subscription lifecycle: Keep the latest row for each external event key.

View task

SQL Case · Easy · 20 min

Subscription lifecycle: Find accounts with no activity after the first active month's end

Subscription lifecycle: Find accounts with no activity after the first active month's end.

View task

SQL Case · Medium · 30 min

Subscription lifecycle: Find completed events above the same account's completed-event average

Subscription lifecycle: Find completed events above the same account's completed-event average.

View task

SQL Case · Easy · 20 min

Subscription lifecycle: Return the first subscription_activated timestamp for each account that succeeded

Subscription lifecycle: Return the first subscriptionactivated timestamp for each account that succeeded.

View task

SQL Case · Easy · 20 min

Subscription lifecycle: Find events whose plan reference does not exist

Subscription lifecycle: Find events whose plan reference does not exist.

View task

SQL Case · Easy · 20 min

Subscription lifecycle: Return the latest event for each account

Subscription lifecycle: Return the latest event for each account.

View task

SQL Case · Hard · 45 min

Subscription lifecycle: Return one row per account with completed lifetime value and latest completed event

Subscription lifecycle: Return one row per account with completed lifetime value and latest completed event.

View task

SQL Case · Easy · 20 min

Subscription lifecycle: Combine live and archived completed events without accidental deduplication

Subscription lifecycle: Combine live and archived completed events without accidental deduplication.

View task

SQL Case · Medium · 30 min

Subscription lifecycle: Compare completed value with the previous active month

Subscription lifecycle: Compare completed value with the previous active month.

View task

SQL Case · Medium · 30 min

Subscription lifecycle: Calculate the completed-event rate for every plan with activity

Subscription lifecycle: Calculate the completed-event rate for every plan with activity.

View task

SQL Case · Hard · 45 min

Subscription lifecycle: Resolve every plan to its root plan

Subscription lifecycle: Resolve every plan to its root plan.

View task

SQL Case · Medium · 30 min

Subscription lifecycle: Count accounts that produced trial_started and later produced subscription_activated

Subscription lifecycle: Count accounts that produced trialstarted and later produced subscriptionactivated.

View task

SQL Case · Medium · 30 min

Subscription lifecycle: Rank accounts by completed amount inside each region

Subscription lifecycle: Rank accounts by completed amount inside each region.

View task

SQL Case · Medium · 30 min

Subscription lifecycle: Find subscription_activated events that happened within seven days of the same account's previous success

Subscription lifecycle: Find subscriptionactivated events that happened within seven days of the same account's previous success.

View task

SQL Case · Hard · 45 min

Subscription lifecycle: Calculate the rolling average over each account's current and previous two events

Subscription lifecycle: Calculate the rolling average over each account's current and previous two events.

View task

SQL Case · Medium · 30 min

Subscription lifecycle: Measure the share of accounts in each segment that ever reached subscription_activated

Subscription lifecycle: Measure the share of accounts in each segment that ever reached subscriptionactivated.

View task

SQL Case · Medium · 30 min

Subscription lifecycle: Split each account's events when inactivity exceeds 30 minutes

Subscription lifecycle: Split each account's events when inactivity exceeds 30 minutes.

View task

SQL Case · Easy · 20 min

Subscription lifecycle: Produce one status summary row per account

Subscription lifecycle: Produce one status summary row per account.

View task

SQL Case · Medium · 30 min

Subscription lifecycle: Find the plan with the largest completed value in each category

Subscription lifecycle: Find the plan with the largest completed value in each category.

View task