SQL Practice Logo

SQLPractice Online

Company SQL Question

Peak Hour Analysis

Practice this Uber style SQL interview question with live execution and instant feedback.

Problem Statement

Identify peak hours for trips by calculating the number of trips and average fare for each hour of the day. Show hour, trip count, and average fare.

Relevant Tables

trips

SQL Concepts Used in This Question

Strengthen your understanding with these targeted learning topics: