The Midnight Shifter

Mission brief

Challenge Briefing

Medium

Date Functions
GROUP BY
Sorting

A local security firm is auditing their "Midnight Shift" rotations. Certain employees specialize in these graveyard shifts, which are uniquely defined by starting on one day and ending on the next. Your mission is to find the ID of the employee who has completed the highest number of these midnight-crossing shifts.

The Midnight Shifter

Identify the employee who consistently works shifts that cross midnight.

The Narrative

Schema Diagram

shifts

employee_idINT

shift_startDATETIME

shift_endDATETIME

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 Skimming Intern	Medium	Not solved	Solve
Git Blame Detective	Medium	Not solved	Solve
The Shadow Follower	Hard	Not solved	Solve

coders.sh *

The Midnight Shifter

The Narrative

Schema Diagram

Challenge a Friend

SQL Editor

Terminal Output

Try another challenge