coders.sh *

Loading Developers Heaven

The Partial Plate

Mission brief

Easy

A witness saw a hit-and-run. They saw a red car, model starting with "S", and a plate containing "77". Find the owner's phone number.

Find the car owner's phone number based on partial details.

A witness saw a hit-and-run. They saw a red car, model starting with "S", and a plate containing "77". Find the owner's phone number.

vehicles

plateVARCHAR

colorVARCHAR

modelVARCHAR

owner_phoneVARCHAR

One SQL table. One SQL condition.
Still tricky for most developers.

Initializing Database Engine v1.8.0...

Write a SQL query, then click Run Query

Keep practicing

Similar difficulty and topics — pick up where you left off or stretch your SQL skills.

Title	Complexity	Status	Solve
The Ghost of 2020	Easy	Not solved	Solve
Git Blame Detective	Medium	Not solved	Solve
Deadlock Recovery	Easy	Not solved	Solve