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.
SQL Case · Medium · 30 min
Media engagement: Find playcompleted events that happened within seven days of the same viewer's previous success.
View taskSQL Case · Hard · 45 min
Media engagement: Calculate the rolling average over each viewer's current and previous two events.
View taskSQL Case · Medium · 30 min
Media engagement: Measure the share of viewers in each segment that ever reached playcompleted.
View taskSQL Case · Medium · 30 min
Media engagement: Split each viewer's events when inactivity exceeds 30 minutes.
View taskSQL Case · Easy · 20 min
Media engagement: Produce one status summary row per viewer.
View taskSQL Case · Medium · 30 min
Media engagement: Find the title with the largest completed value in each category.
View taskSQL Case · Medium · 30 min
Media engagement: Return the two highest-value viewers in each segment.
View taskSQL Case · Easy · 20 min
Media engagement: List viewers that never produced a playcompleted event.
View taskSQL Case · Hard · 45 min
Messaging delivery: Find completed events whose amount exceeds their sender segment's completed-event average.
View taskSQL Case · Medium · 30 min
Messaging delivery: Find senders that reached messagedelivered no more than seven days after creation.
View taskSQL Case · Medium · 30 min
Messaging delivery: Return sender-channel relationships active ten days after the first relationship began.
View taskSQL Case · Easy · 20 min
Messaging delivery: Find senders with at least two recorded events.
View taskSQL Case · Hard · 45 min
Messaging delivery: Calculate each channel category's share of all completed value.
View taskSQL Case · Easy · 20 min
Messaging delivery: Calculate completed event value for each sender segment.
View taskSQL Case · Hard · 45 min
Messaging delivery: Group consecutive active dates into islands for each sender.
View taskSQL Case · Easy · 20 min
Messaging delivery: Count distinct senders with activity on each day.
View taskSQL Case · Medium · 30 min
Messaging delivery: Calculate daily completed value and its running total.
View taskSQL Case · Hard · 45 min
Messaging delivery: Measure whether each creation-date cohort returned on the next calendar day.
View taskSQL Case · Medium · 30 min
Messaging delivery: Keep the latest row for each external event key.
View taskSQL Case · Easy · 20 min
Messaging delivery: Find senders with no activity after the first active month's end.
View taskSQL Case · Medium · 30 min
Messaging delivery: Find completed events above the same sender's completed-event average.
View taskSQL Case · Easy · 20 min
Messaging delivery: Return the first messagedelivered timestamp for each sender that succeeded.
View taskSQL Case · Easy · 20 min
Messaging delivery: Find events whose channel reference does not exist.
View taskSQL Case · Easy · 20 min
Messaging delivery: Return the latest event for each sender.
View taskSQL Case · Hard · 45 min
Messaging delivery: Return one row per sender with completed lifetime value and latest completed event.
View taskSQL Case · Easy · 20 min
Messaging delivery: Combine live and archived completed events without accidental deduplication.
View taskSQL Case · Medium · 30 min
Messaging delivery: Compare completed value with the previous active month.
View taskSQL Case · Medium · 30 min
Messaging delivery: Calculate the completed-event rate for every channel with activity.
View taskSQL Case · Hard · 45 min
Messaging delivery: Resolve every channel to its root channel.
View taskSQL Case · Medium · 30 min
Messaging delivery: Count senders that produced messagequeued and later produced messagedelivered.
View taskSQL Case · Medium · 30 min
Messaging delivery: Rank senders by completed amount inside each region.
View taskSQL Case · Medium · 30 min
Messaging delivery: Find messagedelivered events that happened within seven days of the same sender's previous success.
View taskSQL Case · Hard · 45 min
Messaging delivery: Calculate the rolling average over each sender's current and previous two events.
View taskSQL Case · Medium · 30 min
Messaging delivery: Measure the share of senders in each segment that ever reached messagedelivered.
View taskSQL Case · Medium · 30 min
Messaging delivery: Split each sender's events when inactivity exceeds 30 minutes.
View taskSQL Case · Easy · 20 min
Messaging delivery: Produce one status summary row per sender.
View taskSQL Case · Medium · 30 min
Messaging delivery: Find the channel with the largest completed value in each category.
View taskSQL Case · Medium · 30 min
Messaging delivery: Return the two highest-value senders in each segment.
View taskSQL Case · Easy · 20 min
Messaging delivery: List senders that never produced a messagedelivered event.
View taskSQL Case · Hard · 45 min
Model prediction analytics: Find completed events whose amount exceeds their consumer segment's completed-event average.
View taskSQL Case · Medium · 30 min
Model prediction analytics: Find consumers that reached predictionaccepted no more than seven days after creation.
View taskSQL Case · Medium · 30 min
Model prediction analytics: Return consumer-model relationships active ten days after the first relationship began.
View taskSQL Case · Easy · 20 min
Model prediction analytics: Find consumers with at least two recorded events.
View taskSQL Case · Hard · 45 min
Model prediction analytics: Calculate each model category's share of all completed value.
View taskSQL Case · Easy · 20 min
Model prediction analytics: Calculate completed event value for each consumer segment.
View taskSQL Case · Hard · 45 min
Model prediction analytics: Group consecutive active dates into islands for each consumer.
View taskSQL Case · Easy · 20 min
Model prediction analytics: Count distinct consumers with activity on each day.
View taskSQL Case · Medium · 30 min
Model prediction analytics: Calculate daily completed value and its running total.
View task