Platform Speed

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

Domain

SQL

Difficulty

medium

Problem

The product team is investigating whether device type affects how long users stay engaged. For each device type, show the typical session length, the longest session on record, and how many sessions were logged. Only include device types that have at least five sessions in the data , anything with fewer isn't statistically meaningful. List from the device type with the longest average session down to the 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.