Session Pulse

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

Domain

SQL

Difficulty

easy

Problem

The product manager is investigating engagement drops and wants a per-user session summary. For each user, show their average session length, the total number of sessions, and the longest session they have had. Exclude any sessions with no duration on file. Only include users who have logged at least three sessions, ranked from longest average session to shortest.

Practice This Problem

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