Tenure Mentorship Match

A medium SQL interview practice problem on DataDriven. Write and execute real sql code with instant grading.

Domain

SQL

Difficulty

medium

Seniority

L4

Problem

The engineering org is piloting a mentorship program that pairs each engineer with the most tenured colleague on the same service, using the earliest deployment timestamp as a proxy for tenure. For each author, show them alongside their service's most tenured deployer.

Summary

Pair by tenure. Longest with newest.

Practice This Problem

Solve this SQL problem with real code execution. DataDriven runs your SQL queries against a real database and grades it automatically.