Company SQL Question

Trips in Surge Pricing

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

Problem Statement

Find all completed trips where surge pricing was applied (surge_multiplier > 1.0). Show trip ID, rider name, driver name, surge multiplier, and fare amount.

Relevant Tables

tripsridersdrivers

SQL Concepts Used in This Question

Strengthen your understanding with these targeted learning topics:

Window Functions FundamentalsWindow Functions
Running Totals & Moving AveragesWindow Functions
INNER JOIN Deep DiveJoins & Relationships