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

SQL Case · Hard · 45 min

Game economy: Find completed events whose amount exceeds their player segment's completed-event average

Game economy: Find completed events whose amount exceeds their player segment's completed-event average.

View task

SQL Case · Medium · 30 min

Game economy: Find players that reached match_completed no more than seven days after creation

Game economy: Find players that reached matchcompleted no more than seven days after creation.

View task

SQL Case · Medium · 30 min

Game economy: Return player-game_mode relationships active ten days after the first relationship began

Game economy: Return player-gamemode relationships active ten days after the first relationship began.

View task

SQL Case · Easy · 20 min

Game economy: Find players with at least two recorded events

Game economy: Find players with at least two recorded events.

View task

SQL Case · Hard · 45 min

Game economy: Calculate each game_mode category's share of all completed value

Game economy: Calculate each gamemode category's share of all completed value.

View task

SQL Case · Easy · 20 min

Game economy: Calculate completed event value for each player segment

Game economy: Calculate completed event value for each player segment.

View task

SQL Case · Hard · 45 min

Game economy: Group consecutive active dates into islands for each player

Game economy: Group consecutive active dates into islands for each player.

View task

SQL Case · Easy · 20 min

Game economy: Count distinct players with activity on each day

Game economy: Count distinct players with activity on each day.

View task

SQL Case · Medium · 30 min

Game economy: Calculate daily completed value and its running total

Game economy: Calculate daily completed value and its running total.

View task

SQL Case · Hard · 45 min

Game economy: Measure whether each creation-date cohort returned on the next calendar day

Game economy: Measure whether each creation-date cohort returned on the next calendar day.

View task

SQL Case · Medium · 30 min

Game economy: Keep the latest row for each external event key

Game economy: Keep the latest row for each external event key.

View task

SQL Case · Easy · 20 min

Game economy: Find players with no activity after the first active month's end

Game economy: Find players with no activity after the first active month's end.

View task

SQL Case · Medium · 30 min

Game economy: Find completed events above the same player's completed-event average

Game economy: Find completed events above the same player's completed-event average.

View task

SQL Case · Easy · 20 min

Game economy: Return the first match_completed timestamp for each player that succeeded

Game economy: Return the first matchcompleted timestamp for each player that succeeded.

View task

SQL Case · Easy · 20 min

Game economy: Find events whose game_mode reference does not exist

Game economy: Find events whose gamemode reference does not exist.

View task

SQL Case · Easy · 20 min

Game economy: Return the latest event for each player

Game economy: Return the latest event for each player.

View task

SQL Case · Hard · 45 min

Game economy: Return one row per player with completed lifetime value and latest completed event

Game economy: Return one row per player with completed lifetime value and latest completed event.

View task

SQL Case · Easy · 20 min

Game economy: Combine live and archived completed events without accidental deduplication

Game economy: Combine live and archived completed events without accidental deduplication.

View task

SQL Case · Medium · 30 min

Game economy: Compare completed value with the previous active month

Game economy: Compare completed value with the previous active month.

View task

SQL Case · Medium · 30 min

Game economy: Calculate the completed-event rate for every game_mode with activity

Game economy: Calculate the completed-event rate for every gamemode with activity.

View task

SQL Case · Hard · 45 min

Game economy: Resolve every game_mode to its root game_mode

Game economy: Resolve every gamemode to its root gamemode.

View task

SQL Case · Medium · 30 min

Game economy: Count players that produced session_started and later produced match_completed

Game economy: Count players that produced sessionstarted and later produced matchcompleted.

View task

SQL Case · Medium · 30 min

Game economy: Rank players by completed amount inside each region

Game economy: Rank players by completed amount inside each region.

View task

SQL Case · Medium · 30 min

Game economy: Find match_completed events that happened within seven days of the same player's previous success

Game economy: Find matchcompleted events that happened within seven days of the same player's previous success.

View task

SQL Case · Hard · 45 min

Game economy: Calculate the rolling average over each player's current and previous two events

Game economy: Calculate the rolling average over each player's current and previous two events.

View task

SQL Case · Medium · 30 min

Game economy: Measure the share of players in each segment that ever reached match_completed

Game economy: Measure the share of players in each segment that ever reached matchcompleted.

View task

SQL Case · Medium · 30 min

Game economy: Split each player's events when inactivity exceeds 30 minutes

Game economy: Split each player's events when inactivity exceeds 30 minutes.

View task

SQL Case · Easy · 20 min

Game economy: Produce one status summary row per player

Game economy: Produce one status summary row per player.

View task

SQL Case · Medium · 30 min

Game economy: Find the game_mode with the largest completed value in each category

Game economy: Find the gamemode with the largest completed value in each category.

View task

SQL Case · Medium · 30 min

Game economy: Return the two highest-value players in each segment

Game economy: Return the two highest-value players in each segment.

View task

SQL Case · Easy · 20 min

Game economy: List players that never produced a match_completed event

Game economy: List players that never produced a matchcompleted event.

View task

SQL Case · Hard · 45 min

Healthcare operations: Find completed events whose amount exceeds their patient segment's completed-event average

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

View task

SQL Case · Medium · 30 min

Healthcare operations: Find patients that reached visit_completed no more than seven days after creation

Healthcare operations: Find patients that reached visitcompleted no more than seven days after creation.

View task

SQL Case · Medium · 30 min

Healthcare operations: Return patient-care_path relationships active ten days after the first relationship began

Healthcare operations: Return patient-carepath relationships active ten days after the first relationship began.

View task

SQL Case · Easy · 20 min

Healthcare operations: Find patients with at least two recorded events

Healthcare operations: Find patients with at least two recorded events.

View task

SQL Case · Hard · 45 min

Healthcare operations: Calculate each care_path category's share of all completed value

Healthcare operations: Calculate each carepath category's share of all completed value.

View task

SQL Case · Easy · 20 min

Healthcare operations: Calculate completed event value for each patient segment

Healthcare operations: Calculate completed event value for each patient segment.

View task

SQL Case · Hard · 45 min

Healthcare operations: Group consecutive active dates into islands for each patient

Healthcare operations: Group consecutive active dates into islands for each patient.

View task

SQL Case · Easy · 20 min

Healthcare operations: Count distinct patients with activity on each day

Healthcare operations: Count distinct patients with activity on each day.

View task

SQL Case · Medium · 30 min

Healthcare operations: Calculate daily completed value and its running total

Healthcare operations: Calculate daily completed value and its running total.

View task

SQL Case · Hard · 45 min

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

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

View task

SQL Case · Medium · 30 min

Healthcare operations: Keep the latest row for each external event key

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

View task

SQL Case · Easy · 20 min

Healthcare operations: Find patients with no activity after the first active month's end

Healthcare operations: Find patients with no activity after the first active month's end.

View task

SQL Case · Medium · 30 min

Healthcare operations: Find completed events above the same patient's completed-event average

Healthcare operations: Find completed events above the same patient's completed-event average.

View task

SQL Case · Easy · 20 min

Healthcare operations: Return the first visit_completed timestamp for each patient that succeeded

Healthcare operations: Return the first visitcompleted timestamp for each patient that succeeded.

View task

SQL Case · Easy · 20 min

Healthcare operations: Find events whose care_path reference does not exist

Healthcare operations: Find events whose carepath reference does not exist.

View task

SQL Case · Easy · 20 min

Healthcare operations: Return the latest event for each patient

Healthcare operations: Return the latest event for each patient.

View task

SQL Case · Hard · 45 min

Healthcare operations: Return one row per patient with completed lifetime value and latest completed event

Healthcare operations: Return one row per patient with completed lifetime value and latest completed event.

View task