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

SQL Case · Medium · 30 min

Subscription lifecycle: Return the two highest-value accounts in each segment

Subscription lifecycle: Return the two highest-value accounts in each segment.

View task

SQL Case · Easy · 20 min

Subscription lifecycle: List accounts that never produced a subscription_activated event

Subscription lifecycle: List accounts that never produced a subscriptionactivated event.

View task

SQL Case · Hard · 45 min

Support SLA operations: Find completed events whose amount exceeds their customer segment's completed-event average

Support SLA operations: Find completed events whose amount exceeds their customer segment's completed-event average.

View task

SQL Case · Medium · 30 min

Support SLA operations: Find customers that reached ticket_resolved no more than seven days after creation

Support SLA operations: Find customers that reached ticketresolved no more than seven days after creation.

View task

SQL Case · Medium · 30 min

Support SLA operations: Return customer-queue relationships active ten days after the first relationship began

Support SLA operations: Return customer-queue relationships active ten days after the first relationship began.

View task

SQL Case · Easy · 20 min

Support SLA operations: Find customers with at least two recorded events

Support SLA operations: Find customers with at least two recorded events.

View task

SQL Case · Hard · 45 min

Support SLA operations: Calculate each queue category's share of all completed value

Support SLA operations: Calculate each queue category's share of all completed value.

View task

SQL Case · Easy · 20 min

Support SLA operations: Calculate completed event value for each customer segment

Support SLA operations: Calculate completed event value for each customer segment.

View task

SQL Case · Hard · 45 min

Support SLA operations: Group consecutive active dates into islands for each customer

Support SLA operations: Group consecutive active dates into islands for each customer.

View task

SQL Case · Easy · 20 min

Support SLA operations: Count distinct customers with activity on each day

Support SLA operations: Count distinct customers with activity on each day.

View task

SQL Case · Medium · 30 min

Support SLA operations: Calculate daily completed value and its running total

Support SLA operations: Calculate daily completed value and its running total.

View task

SQL Case · Hard · 45 min

Support SLA operations: Measure whether each creation-date cohort returned on the next calendar day

Support SLA operations: Measure whether each creation-date cohort returned on the next calendar day.

View task

SQL Case · Medium · 30 min

Support SLA operations: Keep the latest row for each external event key

Support SLA operations: Keep the latest row for each external event key.

View task

SQL Case · Easy · 20 min

Support SLA operations: Find customers with no activity after the first active month's end

Support SLA operations: Find customers with no activity after the first active month's end.

View task

SQL Case · Medium · 30 min

Support SLA operations: Find completed events above the same customer's completed-event average

Support SLA operations: Find completed events above the same customer's completed-event average.

View task

SQL Case · Easy · 20 min

Support SLA operations: Return the first ticket_resolved timestamp for each customer that succeeded

Support SLA operations: Return the first ticketresolved timestamp for each customer that succeeded.

View task

SQL Case · Easy · 20 min

Support SLA operations: Find events whose queue reference does not exist

Support SLA operations: Find events whose queue reference does not exist.

View task

SQL Case · Easy · 20 min

Support SLA operations: Return the latest event for each customer

Support SLA operations: Return the latest event for each customer.

View task

SQL Case · Hard · 45 min

Support SLA operations: Return one row per customer with completed lifetime value and latest completed event

Support SLA operations: Return one row per customer with completed lifetime value and latest completed event.

View task

SQL Case · Easy · 20 min

Support SLA operations: Combine live and archived completed events without accidental deduplication

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

View task

SQL Case · Medium · 30 min

Support SLA operations: Compare completed value with the previous active month

Support SLA operations: Compare completed value with the previous active month.

View task

SQL Case · Medium · 30 min

Support SLA operations: Calculate the completed-event rate for every queue with activity

Support SLA operations: Calculate the completed-event rate for every queue with activity.

View task

SQL Case · Hard · 45 min

Support SLA operations: Resolve every queue to its root queue

Support SLA operations: Resolve every queue to its root queue.

View task

SQL Case · Medium · 30 min

Support SLA operations: Count customers that produced ticket_opened and later produced ticket_resolved

Support SLA operations: Count customers that produced ticketopened and later produced ticketresolved.

View task

SQL Case · Medium · 30 min

Support SLA operations: Rank customers by completed amount inside each region

Support SLA operations: Rank customers by completed amount inside each region.

View task

SQL Case · Medium · 30 min

Support SLA operations: Find ticket_resolved events that happened within seven days of the same customer's previous success

Support SLA operations: Find ticketresolved events that happened within seven days of the same customer's previous success.

View task

SQL Case · Hard · 45 min

Support SLA operations: Calculate the rolling average over each customer's current and previous two events

Support SLA operations: Calculate the rolling average over each customer's current and previous two events.

View task

SQL Case · Medium · 30 min

Support SLA operations: Measure the share of customers in each segment that ever reached ticket_resolved

Support SLA operations: Measure the share of customers in each segment that ever reached ticketresolved.

View task

SQL Case · Medium · 30 min

Support SLA operations: Split each customer's events when inactivity exceeds 30 minutes

Support SLA operations: Split each customer's events when inactivity exceeds 30 minutes.

View task

SQL Case · Easy · 20 min

Support SLA operations: Produce one status summary row per customer

Support SLA operations: Produce one status summary row per customer.

View task

SQL Case · Medium · 30 min

Support SLA operations: Find the queue with the largest completed value in each category

Support SLA operations: Find the queue with the largest completed value in each category.

View task

SQL Case · Medium · 30 min

Support SLA operations: Return the two highest-value customers in each segment

Support SLA operations: Return the two highest-value customers in each segment.

View task

SQL Case · Easy · 20 min

Support SLA operations: List customers that never produced a ticket_resolved event

Support SLA operations: List customers that never produced a ticketresolved event.

View task

SQL Case · Hard · 45 min

Travel booking: Find completed events whose amount exceeds their traveler segment's completed-event average

Travel booking: Find completed events whose amount exceeds their traveler segment's completed-event average.

View task

SQL Case · Medium · 30 min

Travel booking: Find travelers that reached booking_confirmed no more than seven days after creation

Travel booking: Find travelers that reached bookingconfirmed no more than seven days after creation.

View task

SQL Case · Medium · 30 min

Travel booking: Return traveler-itinerary relationships active ten days after the first relationship began

Travel booking: Return traveler-itinerary relationships active ten days after the first relationship began.

View task

SQL Case · Easy · 20 min

Travel booking: Find travelers with at least two recorded events

Travel booking: Find travelers with at least two recorded events.

View task

SQL Case · Hard · 45 min

Travel booking: Calculate each itinerary category's share of all completed value

Travel booking: Calculate each itinerary category's share of all completed value.

View task

SQL Case · Easy · 20 min

Travel booking: Calculate completed event value for each traveler segment

Travel booking: Calculate completed event value for each traveler segment.

View task

SQL Case · Hard · 45 min

Travel booking: Group consecutive active dates into islands for each traveler

Travel booking: Group consecutive active dates into islands for each traveler.

View task

SQL Case · Easy · 20 min

Travel booking: Count distinct travelers with activity on each day

Travel booking: Count distinct travelers with activity on each day.

View task

SQL Case · Medium · 30 min

Travel booking: Calculate daily completed value and its running total

Travel booking: Calculate daily completed value and its running total.

View task

SQL Case · Hard · 45 min

Travel booking: Measure whether each creation-date cohort returned on the next calendar day

Travel booking: Measure whether each creation-date cohort returned on the next calendar day.

View task

SQL Case · Medium · 30 min

Travel booking: Keep the latest row for each external event key

Travel booking: Keep the latest row for each external event key.

View task

SQL Case · Easy · 20 min

Travel booking: Find travelers with no activity after the first active month's end

Travel booking: Find travelers with no activity after the first active month's end.

View task

SQL Case · Medium · 30 min

Travel booking: Find completed events above the same traveler's completed-event average

Travel booking: Find completed events above the same traveler's completed-event average.

View task

SQL Case · Easy · 20 min

Travel booking: Return the first booking_confirmed timestamp for each traveler that succeeded

Travel booking: Return the first bookingconfirmed timestamp for each traveler that succeeded.

View task

SQL Case · Easy · 20 min

Travel booking: Find events whose itinerary reference does not exist

Travel booking: Find events whose itinerary reference does not exist.

View task