coders.sh *

Loading Developers Heaven

Git Blame Detective

Mission brief

Challenge Briefing

Medium

Date Functions
strftime
Filtering

It’s Friday at 5:00 PM. Production is down, the CEO is pinging everyone on Slack, and all signs point to a specific "Quick Fix" merged just an hour ago. We need to identify the author of the commit that broke the main branch so we can revert it and head home.

Git Blame Detective

Locate the developer responsible for a critical Friday afternoon bug.

The Narrative

Schema Diagram

commits

idVARCHAR

authorVARCHAR

branchVARCHAR

commit_timeDATETIME

Challenge a Friend

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

SQL Editor

Terminal Output

Initializing Database Engine v1.8.0...

Write a SQL query, then click Run Query

Keep practicing

Try another challenge

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

View all

Title	Complexity	Status	Solve
The Ghost of 2020	Easy	Not solved	Solve
The Skimming Intern	Medium	Not solved	Solve
The Slow Query Hunt	Medium	Not solved	Solve