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