Where the Minutes Go

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 wants a per-user engagement snapshot that pairs how long people stayed with how much of the site they explored. For each user, give their total session time rounded to the nearest minute alongside the number of different pages they viewed, counting zero for users who had sessions but never opened a page.

Summary

Time spent, and everything they touched.

Practice This Problem

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