Show each user session's session_id, user_id, and the total number of sessions for that user

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

Domain

SQL

Difficulty

medium

Problem

Show each user session's session_id, user_id, and the total number of sessions for that user. Use COUNT(*) with OVER and PARTITION BY. Call the count column user_session_count.

Practice This Problem

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