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

SQL Case · Easy · 20 min

Identity and access: Find principals with at least two recorded events

Identity and access: Find principals with at least two recorded events.

View task

SQL Case · Hard · 45 min

Identity and access: Calculate each resource category's share of all completed value

Identity and access: Calculate each resource category's share of all completed value.

View task

SQL Case · Easy · 20 min

Identity and access: Calculate completed event value for each principal segment

Identity and access: Calculate completed event value for each principal segment.

View task

SQL Case · Hard · 45 min

Identity and access: Group consecutive active dates into islands for each principal

Identity and access: Group consecutive active dates into islands for each principal.

View task

SQL Case · Easy · 20 min

Identity and access: Count distinct principals with activity on each day

Identity and access: Count distinct principals with activity on each day.

View task

SQL Case · Medium · 30 min

Identity and access: Calculate daily completed value and its running total

Identity and access: Calculate daily completed value and its running total.

View task

SQL Case · Hard · 45 min

Identity and access: Measure whether each creation-date cohort returned on the next calendar day

Identity and access: Measure whether each creation-date cohort returned on the next calendar day.

View task

SQL Case · Medium · 30 min

Identity and access: Keep the latest row for each external event key

Identity and access: Keep the latest row for each external event key.

View task

SQL Case · Easy · 20 min

Identity and access: Find principals with no activity after the first active month's end

Identity and access: Find principals with no activity after the first active month's end.

View task

SQL Case · Medium · 30 min

Identity and access: Find completed events above the same principal's completed-event average

Identity and access: Find completed events above the same principal's completed-event average.

View task

SQL Case · Easy · 20 min

Identity and access: Return the first access_granted timestamp for each principal that succeeded

Identity and access: Return the first accessgranted timestamp for each principal that succeeded.

View task

SQL Case · Easy · 20 min

Identity and access: Find events whose resource reference does not exist

Identity and access: Find events whose resource reference does not exist.

View task

SQL Case · Easy · 20 min

Identity and access: Return the latest event for each principal

Identity and access: Return the latest event for each principal.

View task

SQL Case · Hard · 45 min

Identity and access: Return one row per principal with completed lifetime value and latest completed event

Identity and access: Return one row per principal with completed lifetime value and latest completed event.

View task

SQL Case · Easy · 20 min

Identity and access: Combine live and archived completed events without accidental deduplication

Identity and access: Combine live and archived completed events without accidental deduplication.

View task

SQL Case · Medium · 30 min

Identity and access: Compare completed value with the previous active month

Identity and access: Compare completed value with the previous active month.

View task

SQL Case · Medium · 30 min

Identity and access: Calculate the completed-event rate for every resource with activity

Identity and access: Calculate the completed-event rate for every resource with activity.

View task

SQL Case · Hard · 45 min

Identity and access: Resolve every resource to its root resource

Identity and access: Resolve every resource to its root resource.

View task

SQL Case · Medium · 30 min

Identity and access: Count principals that produced access_requested and later produced access_granted

Identity and access: Count principals that produced accessrequested and later produced accessgranted.

View task

SQL Case · Medium · 30 min

Identity and access: Rank principals by completed amount inside each region

Identity and access: Rank principals by completed amount inside each region.

View task

SQL Case · Medium · 30 min

Identity and access: Find access_granted events that happened within seven days of the same principal's previous success

Identity and access: Find accessgranted events that happened within seven days of the same principal's previous success.

View task

SQL Case · Hard · 45 min

Identity and access: Calculate the rolling average over each principal's current and previous two events

Identity and access: Calculate the rolling average over each principal's current and previous two events.

View task

SQL Case · Medium · 30 min

Identity and access: Measure the share of principals in each segment that ever reached access_granted

Identity and access: Measure the share of principals in each segment that ever reached accessgranted.

View task

SQL Case · Medium · 30 min

Identity and access: Split each principal's events when inactivity exceeds 30 minutes

Identity and access: Split each principal's events when inactivity exceeds 30 minutes.

View task

SQL Case · Easy · 20 min

Identity and access: Produce one status summary row per principal

Identity and access: Produce one status summary row per principal.

View task

SQL Case · Medium · 30 min

Identity and access: Find the resource with the largest completed value in each category

Identity and access: Find the resource with the largest completed value in each category.

View task

SQL Case · Medium · 30 min

Identity and access: Return the two highest-value principals in each segment

Identity and access: Return the two highest-value principals in each segment.

View task

SQL Case · Easy · 20 min

Identity and access: List principals that never produced a access_granted event

Identity and access: List principals that never produced a accessgranted event.

View task

SQL Case · Hard · 45 min

Learning product analytics: Find completed events whose amount exceeds their learner segment's completed-event average

Learning product analytics: Find completed events whose amount exceeds their learner segment's completed-event average.

View task

SQL Case · Medium · 30 min

Learning product analytics: Find learners that reached lesson_completed no more than seven days after creation

Learning product analytics: Find learners that reached lessoncompleted no more than seven days after creation.

View task

SQL Case · Medium · 30 min

Learning product analytics: Return learner-course relationships active ten days after the first relationship began

Learning product analytics: Return learner-course relationships active ten days after the first relationship began.

View task

SQL Case · Easy · 20 min

Learning product analytics: Find learners with at least two recorded events

Learning product analytics: Find learners with at least two recorded events.

View task

SQL Case · Hard · 45 min

Learning product analytics: Calculate each course category's share of all completed value

Learning product analytics: Calculate each course category's share of all completed value.

View task

SQL Case · Easy · 20 min

Learning product analytics: Calculate completed event value for each learner segment

Learning product analytics: Calculate completed event value for each learner segment.

View task

SQL Case · Hard · 45 min

Learning product analytics: Group consecutive active dates into islands for each learner

Learning product analytics: Group consecutive active dates into islands for each learner.

View task

SQL Case · Easy · 20 min

Learning product analytics: Count distinct learners with activity on each day

Learning product analytics: Count distinct learners with activity on each day.

View task

SQL Case · Medium · 30 min

Learning product analytics: Calculate daily completed value and its running total

Learning product analytics: Calculate daily completed value and its running total.

View task

SQL Case · Hard · 45 min

Learning product analytics: Measure whether each creation-date cohort returned on the next calendar day

Learning product analytics: Measure whether each creation-date cohort returned on the next calendar day.

View task

SQL Case · Medium · 30 min

Learning product analytics: Keep the latest row for each external event key

Learning product analytics: Keep the latest row for each external event key.

View task

SQL Case · Easy · 20 min

Learning product analytics: Find learners with no activity after the first active month's end

Learning product analytics: Find learners with no activity after the first active month's end.

View task

SQL Case · Medium · 30 min

Learning product analytics: Find completed events above the same learner's completed-event average

Learning product analytics: Find completed events above the same learner's completed-event average.

View task

SQL Case · Easy · 20 min

Learning product analytics: Return the first lesson_completed timestamp for each learner that succeeded

Learning product analytics: Return the first lessoncompleted timestamp for each learner that succeeded.

View task

SQL Case · Easy · 20 min

Learning product analytics: Find events whose course reference does not exist

Learning product analytics: Find events whose course reference does not exist.

View task

SQL Case · Easy · 20 min

Learning product analytics: Return the latest event for each learner

Learning product analytics: Return the latest event for each learner.

View task

SQL Case · Hard · 45 min

Learning product analytics: Return one row per learner with completed lifetime value and latest completed event

Learning product analytics: Return one row per learner with completed lifetime value and latest completed event.

View task

SQL Case · Easy · 20 min

Learning product analytics: Combine live and archived completed events without accidental deduplication

Learning product analytics: Combine live and archived completed events without accidental deduplication.

View task

SQL Case · Medium · 30 min

Learning product analytics: Compare completed value with the previous active month

Learning product analytics: Compare completed value with the previous active month.

View task

SQL Case · Medium · 30 min

Learning product analytics: Calculate the completed-event rate for every course with activity

Learning product analytics: Calculate the completed-event rate for every course with activity.

View task