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

SQL Case · Easy · 20 min

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

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

View task

SQL Case · Medium · 30 min

Healthcare operations: Compare completed value with the previous active month

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

View task

SQL Case · Medium · 30 min

Healthcare operations: Calculate the completed-event rate for every care_path with activity

Healthcare operations: Calculate the completed-event rate for every carepath with activity.

View task

SQL Case · Hard · 45 min

Healthcare operations: Resolve every care_path to its root care_path

Healthcare operations: Resolve every carepath to its root carepath.

View task

SQL Case · Medium · 30 min

Healthcare operations: Count patients that produced visit_started and later produced visit_completed

Healthcare operations: Count patients that produced visitstarted and later produced visitcompleted.

View task

SQL Case · Medium · 30 min

Healthcare operations: Rank patients by completed amount inside each region

Healthcare operations: Rank patients by completed amount inside each region.

View task

SQL Case · Medium · 30 min

Healthcare operations: Find visit_completed events that happened within seven days of the same patient's previous success

Healthcare operations: Find visitcompleted events that happened within seven days of the same patient's previous success.

View task

SQL Case · Hard · 45 min

Healthcare operations: Calculate the rolling average over each patient's current and previous two events

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

View task

SQL Case · Medium · 30 min

Healthcare operations: Measure the share of patients in each segment that ever reached visit_completed

Healthcare operations: Measure the share of patients in each segment that ever reached visitcompleted.

View task

SQL Case · Medium · 30 min

Healthcare operations: Split each patient's events when inactivity exceeds 30 minutes

Healthcare operations: Split each patient's events when inactivity exceeds 30 minutes.

View task

SQL Case · Easy · 20 min

Healthcare operations: Produce one status summary row per patient

Healthcare operations: Produce one status summary row per patient.

View task

SQL Case · Medium · 30 min

Healthcare operations: Find the care_path with the largest completed value in each category

Healthcare operations: Find the carepath with the largest completed value in each category.

View task

SQL Case · Medium · 30 min

Healthcare operations: Return the two highest-value patients in each segment

Healthcare operations: Return the two highest-value patients in each segment.

View task

SQL Case · Easy · 20 min

Healthcare operations: List patients that never produced a visit_completed event

Healthcare operations: List patients that never produced a visitcompleted event.

View task

SQL Case · Hard · 45 min

Hiring funnel analytics: Find completed events whose amount exceeds their candidate segment's completed-event average

Hiring funnel analytics: Find completed events whose amount exceeds their candidate segment's completed-event average.

View task

SQL Case · Medium · 30 min

Hiring funnel analytics: Find candidates that reached offer_accepted no more than seven days after creation

Hiring funnel analytics: Find candidates that reached offeraccepted no more than seven days after creation.

View task

SQL Case · Medium · 30 min

Hiring funnel analytics: Return candidate-position relationships active ten days after the first relationship began

Hiring funnel analytics: Return candidate-position relationships active ten days after the first relationship began.

View task

SQL Case · Easy · 20 min

Hiring funnel analytics: Find candidates with at least two recorded events

Hiring funnel analytics: Find candidates with at least two recorded events.

View task

SQL Case · Hard · 45 min

Hiring funnel analytics: Calculate each position category's share of all completed value

Hiring funnel analytics: Calculate each position category's share of all completed value.

View task

SQL Case · Easy · 20 min

Hiring funnel analytics: Calculate completed event value for each candidate segment

Hiring funnel analytics: Calculate completed event value for each candidate segment.

View task

SQL Case · Hard · 45 min

Hiring funnel analytics: Group consecutive active dates into islands for each candidate

Hiring funnel analytics: Group consecutive active dates into islands for each candidate.

View task

SQL Case · Easy · 20 min

Hiring funnel analytics: Count distinct candidates with activity on each day

Hiring funnel analytics: Count distinct candidates with activity on each day.

View task

SQL Case · Medium · 30 min

Hiring funnel analytics: Calculate daily completed value and its running total

Hiring funnel analytics: Calculate daily completed value and its running total.

View task

SQL Case · Hard · 45 min

Hiring funnel analytics: Measure whether each creation-date cohort returned on the next calendar day

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

View task

SQL Case · Medium · 30 min

Hiring funnel analytics: Keep the latest row for each external event key

Hiring funnel analytics: Keep the latest row for each external event key.

View task

SQL Case · Easy · 20 min

Hiring funnel analytics: Find candidates with no activity after the first active month's end

Hiring funnel analytics: Find candidates with no activity after the first active month's end.

View task

SQL Case · Medium · 30 min

Hiring funnel analytics: Find completed events above the same candidate's completed-event average

Hiring funnel analytics: Find completed events above the same candidate's completed-event average.

View task

SQL Case · Easy · 20 min

Hiring funnel analytics: Return the first offer_accepted timestamp for each candidate that succeeded

Hiring funnel analytics: Return the first offeraccepted timestamp for each candidate that succeeded.

View task

SQL Case · Easy · 20 min

Hiring funnel analytics: Find events whose position reference does not exist

Hiring funnel analytics: Find events whose position reference does not exist.

View task

SQL Case · Easy · 20 min

Hiring funnel analytics: Return the latest event for each candidate

Hiring funnel analytics: Return the latest event for each candidate.

View task

SQL Case · Hard · 45 min

Hiring funnel analytics: Return one row per candidate with completed lifetime value and latest completed event

Hiring funnel analytics: Return one row per candidate with completed lifetime value and latest completed event.

View task

SQL Case · Easy · 20 min

Hiring funnel analytics: Combine live and archived completed events without accidental deduplication

Hiring funnel analytics: Combine live and archived completed events without accidental deduplication.

View task

SQL Case · Medium · 30 min

Hiring funnel analytics: Compare completed value with the previous active month

Hiring funnel analytics: Compare completed value with the previous active month.

View task

SQL Case · Medium · 30 min

Hiring funnel analytics: Calculate the completed-event rate for every position with activity

Hiring funnel analytics: Calculate the completed-event rate for every position with activity.

View task

SQL Case · Hard · 45 min

Hiring funnel analytics: Resolve every position to its root position

Hiring funnel analytics: Resolve every position to its root position.

View task

SQL Case · Medium · 30 min

Hiring funnel analytics: Count candidates that produced application_started and later produced offer_accepted

Hiring funnel analytics: Count candidates that produced applicationstarted and later produced offeraccepted.

View task

SQL Case · Medium · 30 min

Hiring funnel analytics: Rank candidates by completed amount inside each region

Hiring funnel analytics: Rank candidates by completed amount inside each region.

View task

SQL Case · Medium · 30 min

Hiring funnel analytics: Find offer_accepted events that happened within seven days of the same candidate's previous success

Hiring funnel analytics: Find offeraccepted events that happened within seven days of the same candidate's previous success.

View task

SQL Case · Hard · 45 min

Hiring funnel analytics: Calculate the rolling average over each candidate's current and previous two events

Hiring funnel analytics: Calculate the rolling average over each candidate's current and previous two events.

View task

SQL Case · Medium · 30 min

Hiring funnel analytics: Measure the share of candidates in each segment that ever reached offer_accepted

Hiring funnel analytics: Measure the share of candidates in each segment that ever reached offeraccepted.

View task

SQL Case · Medium · 30 min

Hiring funnel analytics: Split each candidate's events when inactivity exceeds 30 minutes

Hiring funnel analytics: Split each candidate's events when inactivity exceeds 30 minutes.

View task

SQL Case · Easy · 20 min

Hiring funnel analytics: Produce one status summary row per candidate

Hiring funnel analytics: Produce one status summary row per candidate.

View task

SQL Case · Medium · 30 min

Hiring funnel analytics: Find the position with the largest completed value in each category

Hiring funnel analytics: Find the position with the largest completed value in each category.

View task

SQL Case · Medium · 30 min

Hiring funnel analytics: Return the two highest-value candidates in each segment

Hiring funnel analytics: Return the two highest-value candidates in each segment.

View task

SQL Case · Easy · 20 min

Hiring funnel analytics: List candidates that never produced a offer_accepted event

Hiring funnel analytics: List candidates that never produced a offeraccepted event.

View task

SQL Case · Hard · 45 min

Identity and access: Find completed events whose amount exceeds their principal segment's completed-event average

Identity and access: Find completed events whose amount exceeds their principal segment's completed-event average.

View task

SQL Case · Medium · 30 min

Identity and access: Find principals that reached access_granted no more than seven days after creation

Identity and access: Find principals that reached accessgranted no more than seven days after creation.

View task

SQL Case · Medium · 30 min

Identity and access: Return principal-resource relationships active ten days after the first relationship began

Identity and access: Return principal-resource relationships active ten days after the first relationship began.

View task