The First Year

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

Domain

SQL

Difficulty

medium

Seniority

L4

Problem

We want to see which users activated early: the ones who logged at least one session within 365 days of signing up. Surface each such user's ID and signup date alongside how many sessions landed inside that first-year window.

Summary

Activated early. A good sign.

Practice This Problem

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