Cold Case~60min

The Operator Badge Riding Free On Every Route But His Own

Operator EMP-19 is assigned to Route-07, where his transit card's $0.00 employee-duty exemption is supposed to apply — but his card tapped $0.00 fare 8 times across 5 completely different routes (Route-01 through Route-05), never once on his own assigned route. EMP-22 also taps $0.00 fare frequently (8 times), but every one of his free taps is on his own assigned route, Route-12 — a normal duty commute exemption.

Tables you'll query

employeestransit_cardsvalidator_taps

What you'll learn

JOINsAggregations & GROUP BYDate & Time Functions
Investigate this case →