Scenario SQL Question

Identify Peak Transaction Hours

Build mastery in Date Operations with this scenario-based SQL challenge and live execution support.

Problem Statement

Write a query to identify peak transaction hours during the day. Return hour_of_day, transaction_count, total_amount, and time_period classification (Morning Peak: 9-11, Lunch Peak: 12-14, Evening Peak: 17-19, Off-Peak: others).

Relevant Tables

orders

SQL Concepts Used in This Scenario

Strengthen your understanding with these targeted learning topics:

Date & Time FunctionsSQL Fundamentals
Range & Interval FilteringAdvanced Filtering
NULL HandlingSQL Fundamentals