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

SQL Case · Hard · 45 min

Learning product analytics: Resolve every course to its root course

Learning product analytics: Resolve every course to its root course.

View task

SQL Case · Medium · 30 min

Learning product analytics: Count learners that produced lesson_started and later produced lesson_completed

Learning product analytics: Count learners that produced lessonstarted and later produced lessoncompleted.

View task

SQL Case · Medium · 30 min

Learning product analytics: Rank learners by completed amount inside each region

Learning product analytics: Rank learners by completed amount inside each region.

View task

SQL Case · Medium · 30 min

Learning product analytics: Find lesson_completed events that happened within seven days of the same learner's previous success

Learning product analytics: Find lessoncompleted events that happened within seven days of the same learner's previous success.

View task

SQL Case · Hard · 45 min

Learning product analytics: Calculate the rolling average over each learner's current and previous two events

Learning product analytics: Calculate the rolling average over each learner's current and previous two events.

View task

SQL Case · Medium · 30 min

Learning product analytics: Measure the share of learners in each segment that ever reached lesson_completed

Learning product analytics: Measure the share of learners in each segment that ever reached lessoncompleted.

View task

SQL Case · Medium · 30 min

Learning product analytics: Split each learner's events when inactivity exceeds 30 minutes

Learning product analytics: Split each learner's events when inactivity exceeds 30 minutes.

View task

SQL Case · Easy · 20 min

Learning product analytics: Produce one status summary row per learner

Learning product analytics: Produce one status summary row per learner.

View task

SQL Case · Medium · 30 min

Learning product analytics: Find the course with the largest completed value in each category

Learning product analytics: Find the course with the largest completed value in each category.

View task

SQL Case · Medium · 30 min

Learning product analytics: Return the two highest-value learners in each segment

Learning product analytics: Return the two highest-value learners in each segment.

View task

SQL Case · Easy · 20 min

Learning product analytics: List learners that never produced a lesson_completed event

Learning product analytics: List learners that never produced a lessoncompleted event.

View task

SQL Case · Hard · 45 min

Logistics network: Find completed events whose amount exceeds their carrier segment's completed-event average

Logistics network: Find completed events whose amount exceeds their carrier segment's completed-event average.

View task

SQL Case · Medium · 30 min

Logistics network: Find carriers that reached shipment_delivered no more than seven days after creation

Logistics network: Find carriers that reached shipmentdelivered no more than seven days after creation.

View task

SQL Case · Medium · 30 min

Logistics network: Return carrier-route relationships active ten days after the first relationship began

Logistics network: Return carrier-route relationships active ten days after the first relationship began.

View task

SQL Case · Easy · 20 min

Logistics network: Find carriers with at least two recorded events

Logistics network: Find carriers with at least two recorded events.

View task

SQL Case · Hard · 45 min

Logistics network: Calculate each route category's share of all completed value

Logistics network: Calculate each route category's share of all completed value.

View task

SQL Case · Easy · 20 min

Logistics network: Calculate completed event value for each carrier segment

Logistics network: Calculate completed event value for each carrier segment.

View task

SQL Case · Hard · 45 min

Logistics network: Group consecutive active dates into islands for each carrier

Logistics network: Group consecutive active dates into islands for each carrier.

View task

SQL Case · Easy · 20 min

Logistics network: Count distinct carriers with activity on each day

Logistics network: Count distinct carriers with activity on each day.

View task

SQL Case · Medium · 30 min

Logistics network: Calculate daily completed value and its running total

Logistics network: Calculate daily completed value and its running total.

View task

SQL Case · Hard · 45 min

Logistics network: Measure whether each creation-date cohort returned on the next calendar day

Logistics network: Measure whether each creation-date cohort returned on the next calendar day.

View task

SQL Case · Medium · 30 min

Logistics network: Keep the latest row for each external event key

Logistics network: Keep the latest row for each external event key.

View task

SQL Case · Easy · 20 min

Logistics network: Find carriers with no activity after the first active month's end

Logistics network: Find carriers with no activity after the first active month's end.

View task

SQL Case · Medium · 30 min

Logistics network: Find completed events above the same carrier's completed-event average

Logistics network: Find completed events above the same carrier's completed-event average.

View task

SQL Case · Easy · 20 min

Logistics network: Return the first shipment_delivered timestamp for each carrier that succeeded

Logistics network: Return the first shipmentdelivered timestamp for each carrier that succeeded.

View task

SQL Case · Easy · 20 min

Logistics network: Find events whose route reference does not exist

Logistics network: Find events whose route reference does not exist.

View task

SQL Case · Easy · 20 min

Logistics network: Return the latest event for each carrier

Logistics network: Return the latest event for each carrier.

View task

SQL Case · Hard · 45 min

Logistics network: Return one row per carrier with completed lifetime value and latest completed event

Logistics network: Return one row per carrier with completed lifetime value and latest completed event.

View task

SQL Case · Easy · 20 min

Logistics network: Combine live and archived completed events without accidental deduplication

Logistics network: Combine live and archived completed events without accidental deduplication.

View task

SQL Case · Medium · 30 min

Logistics network: Compare completed value with the previous active month

Logistics network: Compare completed value with the previous active month.

View task

SQL Case · Medium · 30 min

Logistics network: Calculate the completed-event rate for every route with activity

Logistics network: Calculate the completed-event rate for every route with activity.

View task

SQL Case · Hard · 45 min

Logistics network: Resolve every route to its root route

Logistics network: Resolve every route to its root route.

View task

SQL Case · Medium · 30 min

Logistics network: Count carriers that produced shipment_created and later produced shipment_delivered

Logistics network: Count carriers that produced shipmentcreated and later produced shipmentdelivered.

View task

SQL Case · Medium · 30 min

Logistics network: Rank carriers by completed amount inside each region

Logistics network: Rank carriers by completed amount inside each region.

View task

SQL Case · Medium · 30 min

Logistics network: Find shipment_delivered events that happened within seven days of the same carrier's previous success

Logistics network: Find shipmentdelivered events that happened within seven days of the same carrier's previous success.

View task

SQL Case · Hard · 45 min

Logistics network: Calculate the rolling average over each carrier's current and previous two events

Logistics network: Calculate the rolling average over each carrier's current and previous two events.

View task

SQL Case · Medium · 30 min

Logistics network: Measure the share of carriers in each segment that ever reached shipment_delivered

Logistics network: Measure the share of carriers in each segment that ever reached shipmentdelivered.

View task

SQL Case · Medium · 30 min

Logistics network: Split each carrier's events when inactivity exceeds 30 minutes

Logistics network: Split each carrier's events when inactivity exceeds 30 minutes.

View task

SQL Case · Easy · 20 min

Logistics network: Produce one status summary row per carrier

Logistics network: Produce one status summary row per carrier.

View task

SQL Case · Medium · 30 min

Logistics network: Find the route with the largest completed value in each category

Logistics network: Find the route with the largest completed value in each category.

View task

SQL Case · Medium · 30 min

Logistics network: Return the two highest-value carriers in each segment

Logistics network: Return the two highest-value carriers in each segment.

View task

SQL Case · Easy · 20 min

Logistics network: List carriers that never produced a shipment_delivered event

Logistics network: List carriers that never produced a shipmentdelivered event.

View task

SQL Case · Hard · 45 min

Marketplace operations: Find completed events whose amount exceeds their seller segment's completed-event average

Marketplace operations: Find completed events whose amount exceeds their seller segment's completed-event average.

View task

SQL Case · Medium · 30 min

Marketplace operations: Find sellers that reached order_completed no more than seven days after creation

Marketplace operations: Find sellers that reached ordercompleted no more than seven days after creation.

View task

SQL Case · Medium · 30 min

Marketplace operations: Return seller-listing relationships active ten days after the first relationship began

Marketplace operations: Return seller-listing relationships active ten days after the first relationship began.

View task

SQL Case · Easy · 20 min

Marketplace operations: Find sellers with at least two recorded events

Marketplace operations: Find sellers with at least two recorded events.

View task

SQL Case · Hard · 45 min

Marketplace operations: Calculate each listing category's share of all completed value

Marketplace operations: Calculate each listing category's share of all completed value.

View task

SQL Case · Easy · 20 min

Marketplace operations: Calculate completed event value for each seller segment

Marketplace operations: Calculate completed event value for each seller segment.

View task