DB Exercises
0
← Exercises/
Business Analytics•7 of 14
PrevNext
Business AnalyticsAdvancedPRO

Preventive Vehicle Maintenance Mileage Thresholds

Scenario

Fleet safety standards mandate servicing vehicles when mileage driven since last service exceeds 10,000 miles. Fleet managers need a priority list of overdue vehicles.

Task
Query `fleet_vehicles` to compute `miles_since_service` (`current_odometer - last_service_odometer`). Return: 1. `vehicle_id` 2. `license_plate` 3. `current_odometer` 4. `last_service_odometer` 5. `miles_since_service`: (`current_odometer - last_service_odometer`) Filter for vehicles where `miles_since_service >= 10000`. Order results by `miles_since_service` descending.
Expected Output Format

Vehicles overdue for preventative maintenance sorted by overdue miles.

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 “Preventive Vehicle Maintenance Mileage Thresholds” SQL Problem

Business Scenario

Fleet safety standards mandate servicing vehicles when mileage driven since last service exceeds 10,000 miles. Fleet managers need a priority list of overdue vehicles.

Expected Output & Criteria

Vehicles overdue for preventative maintenance sorted by overdue miles.

Database Table Schema (PostgreSQL DDL)

PostgreSQL 16 WASM

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

CREATE TABLE fleet_vehicles (
        vehicle_id INT PRIMARY KEY,
        license_plate VARCHAR(20) NOT NULL,
        current_odometer INT NOT NULL,
        last_service_odometer INT NOT NULL
      );

Target SQL Clauses & Operators

WHEREORDER BY

Want more Business Analytics practice?

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

View Business Analytics Track→