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

SQL Case · Medium · 30 min

Advertising measurement: Find the campaign with the largest completed value in each category

Advertising measurement: Find the campaign with the largest completed value in each category.

View task

SQL Case · Medium · 30 min

Advertising measurement: Return the two highest-value advertisers in each segment

Advertising measurement: Return the two highest-value advertisers in each segment.

View task

SQL Case · Easy · 20 min

Advertising measurement: List advertisers that never produced a conversion_recorded event

Advertising measurement: List advertisers that never produced a conversionrecorded event.

View task

SQL Case · Hard · 45 min

Cloud cost allocation: Find completed events whose amount exceeds their team segment's completed-event average

Cloud cost allocation: Find completed events whose amount exceeds their team segment's completed-event average.

View task

SQL Case · Medium · 30 min

Cloud cost allocation: Find teams that reached usage_billed no more than seven days after creation

Cloud cost allocation: Find teams that reached usagebilled no more than seven days after creation.

View task

SQL Case · Medium · 30 min

Cloud cost allocation: Return team-workload relationships active ten days after the first relationship began

Cloud cost allocation: Return team-workload relationships active ten days after the first relationship began.

View task

SQL Case · Easy · 20 min

Cloud cost allocation: Find teams with at least two recorded events

Cloud cost allocation: Find teams with at least two recorded events.

View task

SQL Case · Hard · 45 min

Cloud cost allocation: Calculate each workload category's share of all completed value

Cloud cost allocation: Calculate each workload category's share of all completed value.

View task

SQL Case · Easy · 20 min

Cloud cost allocation: Calculate completed event value for each team segment

Cloud cost allocation: Calculate completed event value for each team segment.

View task

SQL Case · Hard · 45 min

Cloud cost allocation: Group consecutive active dates into islands for each team

Cloud cost allocation: Group consecutive active dates into islands for each team.

View task

SQL Case · Easy · 20 min

Cloud cost allocation: Count distinct teams with activity on each day

Cloud cost allocation: Count distinct teams with activity on each day.

View task

SQL Case · Medium · 30 min

Cloud cost allocation: Calculate daily completed value and its running total

Cloud cost allocation: Calculate daily completed value and its running total.

View task

SQL Case · Hard · 45 min

Cloud cost allocation: Measure whether each creation-date cohort returned on the next calendar day

Cloud cost allocation: Measure whether each creation-date cohort returned on the next calendar day.

View task

SQL Case · Medium · 30 min

Cloud cost allocation: Keep the latest row for each external event key

Cloud cost allocation: Keep the latest row for each external event key.

View task

SQL Case · Easy · 20 min

Cloud cost allocation: Find teams with no activity after the first active month's end

Cloud cost allocation: Find teams with no activity after the first active month's end.

View task

SQL Case · Medium · 30 min

Cloud cost allocation: Find completed events above the same team's completed-event average

Cloud cost allocation: Find completed events above the same team's completed-event average.

View task

SQL Case · Easy · 20 min

Cloud cost allocation: Return the first usage_billed timestamp for each team that succeeded

Cloud cost allocation: Return the first usagebilled timestamp for each team that succeeded.

View task

SQL Case · Easy · 20 min

Cloud cost allocation: Find events whose workload reference does not exist

Cloud cost allocation: Find events whose workload reference does not exist.

View task

SQL Case · Easy · 20 min

Cloud cost allocation: Return the latest event for each team

Cloud cost allocation: Return the latest event for each team.

View task

SQL Case · Hard · 45 min

Cloud cost allocation: Return one row per team with completed lifetime value and latest completed event

Cloud cost allocation: Return one row per team with completed lifetime value and latest completed event.

View task

SQL Case · Easy · 20 min

Cloud cost allocation: Combine live and archived completed events without accidental deduplication

Cloud cost allocation: Combine live and archived completed events without accidental deduplication.

View task

SQL Case · Medium · 30 min

Cloud cost allocation: Compare completed value with the previous active month

Cloud cost allocation: Compare completed value with the previous active month.

View task

SQL Case · Medium · 30 min

Cloud cost allocation: Calculate the completed-event rate for every workload with activity

Cloud cost allocation: Calculate the completed-event rate for every workload with activity.

View task

SQL Case · Hard · 45 min

Cloud cost allocation: Resolve every workload to its root workload

Cloud cost allocation: Resolve every workload to its root workload.

View task

SQL Case · Medium · 30 min

Cloud cost allocation: Count teams that produced workload_started and later produced usage_billed

Cloud cost allocation: Count teams that produced workloadstarted and later produced usagebilled.

View task

SQL Case · Medium · 30 min

Cloud cost allocation: Rank teams by completed amount inside each region

Cloud cost allocation: Rank teams by completed amount inside each region.

View task

SQL Case · Medium · 30 min

Cloud cost allocation: Find usage_billed events that happened within seven days of the same team's previous success

Cloud cost allocation: Find usagebilled events that happened within seven days of the same team's previous success.

View task

SQL Case · Hard · 45 min

Cloud cost allocation: Calculate the rolling average over each team's current and previous two events

Cloud cost allocation: Calculate the rolling average over each team's current and previous two events.

View task

SQL Case · Medium · 30 min

Cloud cost allocation: Measure the share of teams in each segment that ever reached usage_billed

Cloud cost allocation: Measure the share of teams in each segment that ever reached usagebilled.

View task

SQL Case · Medium · 30 min

Cloud cost allocation: Split each team's events when inactivity exceeds 30 minutes

Cloud cost allocation: Split each team's events when inactivity exceeds 30 minutes.

View task

SQL Case · Easy · 20 min

Cloud cost allocation: Produce one status summary row per team

Cloud cost allocation: Produce one status summary row per team.

View task

SQL Case · Medium · 30 min

Cloud cost allocation: Find the workload with the largest completed value in each category

Cloud cost allocation: Find the workload with the largest completed value in each category.

View task

SQL Case · Medium · 30 min

Cloud cost allocation: Return the two highest-value teams in each segment

Cloud cost allocation: Return the two highest-value teams in each segment.

View task

SQL Case · Easy · 20 min

Cloud cost allocation: List teams that never produced a usage_billed event

Cloud cost allocation: List teams that never produced a usagebilled event.

View task

SQL Case · Hard · 45 min

Developer productivity: Find completed events whose amount exceeds their developer segment's completed-event average

Developer productivity: Find completed events whose amount exceeds their developer segment's completed-event average.

View task

SQL Case · Medium · 30 min

Developer productivity: Find developers that reached build_succeeded no more than seven days after creation

Developer productivity: Find developers that reached buildsucceeded no more than seven days after creation.

View task

SQL Case · Medium · 30 min

Developer productivity: Return developer-repository relationships active ten days after the first relationship began

Developer productivity: Return developer-repository relationships active ten days after the first relationship began.

View task

SQL Case · Easy · 20 min

Developer productivity: Find developers with at least two recorded events

Developer productivity: Find developers with at least two recorded events.

View task

SQL Case · Hard · 45 min

Developer productivity: Calculate each repository category's share of all completed value

Developer productivity: Calculate each repository category's share of all completed value.

View task

SQL Case · Easy · 20 min

Developer productivity: Calculate completed event value for each developer segment

Developer productivity: Calculate completed event value for each developer segment.

View task

SQL Case · Hard · 45 min

Developer productivity: Group consecutive active dates into islands for each developer

Developer productivity: Group consecutive active dates into islands for each developer.

View task

SQL Case · Easy · 20 min

Developer productivity: Count distinct developers with activity on each day

Developer productivity: Count distinct developers with activity on each day.

View task

SQL Case · Medium · 30 min

Developer productivity: Calculate daily completed value and its running total

Developer productivity: Calculate daily completed value and its running total.

View task

SQL Case · Hard · 45 min

Developer productivity: Measure whether each creation-date cohort returned on the next calendar day

Developer productivity: Measure whether each creation-date cohort returned on the next calendar day.

View task

SQL Case · Medium · 30 min

Developer productivity: Keep the latest row for each external event key

Developer productivity: Keep the latest row for each external event key.

View task

SQL Case · Easy · 20 min

Developer productivity: Find developers with no activity after the first active month's end

Developer productivity: Find developers with no activity after the first active month's end.

View task

SQL Case · Medium · 30 min

Developer productivity: Find completed events above the same developer's completed-event average

Developer productivity: Find completed events above the same developer's completed-event average.

View task

SQL Case · Easy · 20 min

Developer productivity: Return the first build_succeeded timestamp for each developer that succeeded

Developer productivity: Return the first buildsucceeded timestamp for each developer that succeeded.

View task