Supercharger Status
ASKED IN INTERVIEWTesla
Problem Statement
Tesla’s network reliability team needs to dispatch technicians to repair faulty Superchargers. They require a real-time list of all charging stations located in the California region that currently have a status of Offline.
Write an SQL query to retrieve these stations.
Rules:
- The region must be exactly California.
- The status must be exactly Offline.
- Output columns: station_id, station_name, last_ping.
- Sort the results by station_id in ascending order.
Table Schema:
- Stations: station_id, station_name, region, status (Online, Offline, Maintenance), last_ping.
Tests your understanding of
Basic SQL, Filtering and Logical Operators
Input Tables
Stations
| station_id(INTEGER) | station_name(VARCHAR) | region(VARCHAR) | status(VARCHAR) | last_ping(TIMESTAMP) |
|---|---|---|---|---|
| 101 | Palo Alto - University Ave | California | Offline | 2026-02-11 08:00:00 |
| 102 | Los Angeles - Santa Monica | California | Online | 2026-02-11 09:30:00 |
| 103 | Seattle - Downtown | Washington | Offline | 2026-02-11 07:00:00 |
| 104 | San Diego - Fashion Valley | California | Offline | 2026-02-11 06:15:00 |
| 105 | Fresno - Highway 99 | California | Maintenance | 2026-02-11 09:00:00 |
| 106 | Burbank - Magnolia | California | Offline | 2026-02-11 09:45:00 |
Expected Output
| station_id(INTEGER) | station_name(VARCHAR) | last_ping(TIMESTAMP) |
|---|---|---|
| 101 | Palo Alto - University Ave | 2026-02-11 08:00:00 |
| 104 | San Diego - Fashion Valley | 2026-02-11 06:15:00 |
| 106 | Burbank - Magnolia | 2026-02-11 09:45:00 |
Tags
EasyASKED IN INTERVIEWBasic SQLFilteringLogical Operators
5 min
89%