Longest Active Membership Streak

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

Domain

SQL

Difficulty

easy

Seniority

L3

Problem

The analytics team is scanning employee_metrics for its standout readings and wants the most extreme ones, with repeated values collapsed to a single entry. Surface the five highest metric values, listed from highest to lowest.

Summary

The longest unbroken streak.

Practice This Problem

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