# Show all users and their sessions longer than 300 seconds

Canonical URL: <https://datadriven.io/problems/show-all-users-and-their-sessions-longer-than-300-seconds-u-d77e0a93>

Domain: SQL · Difficulty: medium

## Problem

Show all users and their sessions longer than 300 seconds. Users with no qualifying sessions should still appear with NULL. Place the duration filter in the ON clause, not WHERE.

## Related

- [All practice problems](https://datadriven.io/problems)
- [Mock interview mode](https://datadriven.io/interview/show-all-users-and-their-sessions-longer-than-300-seconds-u-d77e0a93)
- [SQL Interview Questions](https://datadriven.io/sql-interview-questions)
- [Data Engineering Interview Prep Guide](https://datadriven.io/data-engineer-interview-prep)
- [Daily Challenge](https://datadriven.io/daily)

---

Source: DataDriven (https://datadriven.io). 100% free data engineering interview prep. Live code execution against Postgres 16, Python 3.11, and Spark sandboxes. No paywall, no premium tier, no signup gate.