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

SQL Case · Medium · 30 min

Rank creators by reactions received within each topic

Rank creators by reactions received within each topic.

View task

SQL Case · Hard · 45 min

Build one content-performance row for every user

Build one content-performance row for every user.

View task

SQL Case · Medium · 30 min

Count reactions received within 24 hours after each published post

Count reactions received within 24 hours after each published post.

View task

SQL Case · Medium · 30 min

Count moderated posts and moderation actions for every affected author

Count moderated posts and moderation actions for every affected author.

View task

SQL Case · Easy · 20 min

Find pairs of users who follow each other

Find pairs of users who follow each other.

View task

SQL Case · Easy · 20 min

Count reactions on each published post

Count reactions on each published post.

View task

SQL Case · Medium · 30 min

Find posts that received at least two distinct reaction types

Find posts that received at least two distinct reaction types.

View task

SQL Case · Easy · 20 min

Count reactions received by published posts in each topic

Count reactions received by published posts in each topic.

View task

SQL Case · Hard · 45 min

Generate follow suggestions through two-hop connections

Generate follow suggestions through two-hop connections.

View task

SQL Case · Easy · 20 min

List users who have never authored a post

List users who have never authored a post.

View task

SQL Case · Hard · 45 min

Compare treatment conversion rate with control for each experiment that has both variants

Compare treatment conversion rate with control for each experiment that has both variants.

View task

SQL Case · Easy · 20 min

Count unique assigned users for each experiment variant

Count unique assigned users for each experiment variant.

View task

SQL Case · Medium · 30 min

Find users assigned to more than one variant in the same experiment

Find users assigned to more than one variant in the same experiment.

View task

SQL Case · Easy · 20 min

Calculate purchase conversion by variant for completed experiment assignments

Calculate purchase conversion by variant for completed experiment assignments.

View task

SQL Case · Hard · 45 min

Build one scorecard row per experiment variant with assignment, conversion, and revenue metrics

Build one scorecard row per experiment variant with assignment, conversion, and revenue metrics.

View task

SQL Case · Easy · 20 min

Find assignment rows whose users had a purchase before assignment

Find assignment rows whose users had a purchase before assignment.

View task

SQL Case · Easy · 20 min

Show the percentage of assignments allocated to each variant

Show the percentage of assignments allocated to each variant.

View task

SQL Case · Medium · 30 min

Break post-assignment purchase conversion down by segment and variant

Break post-assignment purchase conversion down by segment and variant.

View task

SQL Case · Medium · 30 min

Measure hours from assignment to each converted user’s first purchase

Measure hours from assignment to each converted user’s first purchase.

View task

SQL Case · Medium · 30 min

Calculate purchase revenue per assigned user for each variant

Calculate purchase revenue per assigned user for each variant.

View task

SQL Case · Hard · 45 min

Advertising measurement: Find completed events whose amount exceeds their advertiser segment's completed-event average

Advertising measurement: Find completed events whose amount exceeds their advertiser segment's completed-event average.

View task

SQL Case · Medium · 30 min

Advertising measurement: Find advertisers that reached conversion_recorded no more than seven days after creation

Advertising measurement: Find advertisers that reached conversionrecorded no more than seven days after creation.

View task

SQL Case · Medium · 30 min

Advertising measurement: Return advertiser-campaign relationships active ten days after the first relationship began

Advertising measurement: Return advertiser-campaign relationships active ten days after the first relationship began.

View task

SQL Case · Easy · 20 min

Advertising measurement: Find advertisers with at least two recorded events

Advertising measurement: Find advertisers with at least two recorded events.

View task

SQL Case · Hard · 45 min

Advertising measurement: Calculate each campaign category's share of all completed value

Advertising measurement: Calculate each campaign category's share of all completed value.

View task

SQL Case · Easy · 20 min

Advertising measurement: Calculate completed event value for each advertiser segment

Advertising measurement: Calculate completed event value for each advertiser segment.

View task

SQL Case · Hard · 45 min

Advertising measurement: Group consecutive active dates into islands for each advertiser

Advertising measurement: Group consecutive active dates into islands for each advertiser.

View task

SQL Case · Easy · 20 min

Advertising measurement: Count distinct advertisers with activity on each day

Advertising measurement: Count distinct advertisers with activity on each day.

View task

SQL Case · Medium · 30 min

Advertising measurement: Calculate daily completed value and its running total

Advertising measurement: Calculate daily completed value and its running total.

View task

SQL Case · Hard · 45 min

Advertising measurement: Measure whether each creation-date cohort returned on the next calendar day

Advertising measurement: Measure whether each creation-date cohort returned on the next calendar day.

View task

SQL Case · Medium · 30 min

Advertising measurement: Keep the latest row for each external event key

Advertising measurement: Keep the latest row for each external event key.

View task

SQL Case · Easy · 20 min

Advertising measurement: Find advertisers with no activity after the first active month's end

Advertising measurement: Find advertisers with no activity after the first active month's end.

View task

SQL Case · Medium · 30 min

Advertising measurement: Find completed events above the same advertiser's completed-event average

Advertising measurement: Find completed events above the same advertiser's completed-event average.

View task

SQL Case · Easy · 20 min

Advertising measurement: Return the first conversion_recorded timestamp for each advertiser that succeeded

Advertising measurement: Return the first conversionrecorded timestamp for each advertiser that succeeded.

View task

SQL Case · Easy · 20 min

Advertising measurement: Find events whose campaign reference does not exist

Advertising measurement: Find events whose campaign reference does not exist.

View task

SQL Case · Easy · 20 min

Advertising measurement: Return the latest event for each advertiser

Advertising measurement: Return the latest event for each advertiser.

View task

SQL Case · Hard · 45 min

Advertising measurement: Return one row per advertiser with completed lifetime value and latest completed event

Advertising measurement: Return one row per advertiser with completed lifetime value and latest completed event.

View task

SQL Case · Easy · 20 min

Advertising measurement: Combine live and archived completed events without accidental deduplication

Advertising measurement: Combine live and archived completed events without accidental deduplication.

View task

SQL Case · Medium · 30 min

Advertising measurement: Compare completed value with the previous active month

Advertising measurement: Compare completed value with the previous active month.

View task

SQL Case · Medium · 30 min

Advertising measurement: Calculate the completed-event rate for every campaign with activity

Advertising measurement: Calculate the completed-event rate for every campaign with activity.

View task

SQL Case · Hard · 45 min

Advertising measurement: Resolve every campaign to its root campaign

Advertising measurement: Resolve every campaign to its root campaign.

View task

SQL Case · Medium · 30 min

Advertising measurement: Count advertisers that produced impression_recorded and later produced conversion_recorded

Advertising measurement: Count advertisers that produced impressionrecorded and later produced conversionrecorded.

View task

SQL Case · Medium · 30 min

Advertising measurement: Rank advertisers by completed amount inside each region

Advertising measurement: Rank advertisers by completed amount inside each region.

View task

SQL Case · Medium · 30 min

Advertising measurement: Find conversion_recorded events that happened within seven days of the same advertiser's previous success

Advertising measurement: Find conversionrecorded events that happened within seven days of the same advertiser's previous success.

View task

SQL Case · Hard · 45 min

Advertising measurement: Calculate the rolling average over each advertiser's current and previous two events

Advertising measurement: Calculate the rolling average over each advertiser's current and previous two events.

View task

SQL Case · Medium · 30 min

Advertising measurement: Measure the share of advertisers in each segment that ever reached conversion_recorded

Advertising measurement: Measure the share of advertisers in each segment that ever reached conversionrecorded.

View task

SQL Case · Medium · 30 min

Advertising measurement: Split each advertiser's events when inactivity exceeds 30 minutes

Advertising measurement: Split each advertiser's events when inactivity exceeds 30 minutes.

View task

SQL Case · Easy · 20 min

Advertising measurement: Produce one status summary row per advertiser

Advertising measurement: Produce one status summary row per advertiser.

View task