From user_sessions, return session_id and DATE_FORMAT(CAST(session_start AS TIMESTAMP), '%Y-%m') AS

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

Domain

SQL

Difficulty

medium

Problem

From user_sessions, return session_id and DATE_FORMAT(CAST(session_start AS TIMESTAMP), '%Y-%m') AS year_month. Order by session_id.

Practice This Problem

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