From user_sessions, return EXTRACT(HOUR FROM CAST(session_start AS TIMESTAMP)) AS hour_of_day and CO

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 EXTRACT(HOUR FROM CAST(session_start AS TIMESTAMP)) AS hour_of_day and COUNT(*) AS sessions. Group and order by hour_of_day.

Practice This Problem

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