DB Exercises
0
← Exercises/
Aggregations•11 of 12
PrevNext
AggregationsIntermediatePRO

Driver Acceptance & Ride Cancellation Benchmarks

Scenario

Ride reliability is essential for platform retention. The city operations manager needs to analyze completed versus canceled rides across different vehicle tiers to spot service breakdown.

Task
Group rides in `ride_requests` by `vehicle_tier`. Calculate: 1. `vehicle_tier` 2. `total_requests`: Total ride requests in that tier 3. `completed_rides`: Count of rides where `status = 'completed'` 4. `completion_rate_pct`: Percentage of rides completed: `ROUND(100.0 * SUM(CASE WHEN status = 'completed' THEN 1 ELSE 0 END) / COUNT(*), 1)` Order results by `completion_rate_pct` descending.
Expected Output Format

Summary of ride requests, completed rides, and completion percentage per vehicle tier.

Input Tables & Sample Data0 tables
Loading database schema...
Need a hint?
query.sql|Local Sandbox
Loading SQL editor...
Click "Run" or press ⌘ + Enter to execute your query

About the “Driver Acceptance & Ride Cancellation Benchmarks” SQL Problem

Business Scenario

Ride reliability is essential for platform retention. The city operations manager needs to analyze completed versus canceled rides across different vehicle tiers to spot service breakdown.

Expected Output & Criteria

Summary of ride requests, completed rides, and completion percentage per vehicle tier.

Database Table Schema (PostgreSQL DDL)

PostgreSQL 16 WASM

This challenge executes directly against the following relational schema in your browser:

CREATE TABLE ride_requests (
        ride_id INT PRIMARY KEY,
        vehicle_tier VARCHAR(20) NOT NULL,
        fare_usd NUMERIC(8, 2) NOT NULL,
        status VARCHAR(20) NOT NULL
      );

Target SQL Clauses & Operators

GROUP BYCOUNTROUNDCASE

Want more Aggregations practice?

Explore the full syllabus of 12 exercises, syntax guides, and interview pitfalls.

View Aggregations Track→