Tricky~21min

The Billed Hour During Approved Leave

6 attorneys billed hours on a day they had an approved full-day leave request — someone kept working (or kept the clock running) on unpaid time off. 9 more attorneys billed hours on a half-day leave date, which is completely normal — they worked the other half.

Tables you'll query

timesheetsleave_requests

What you'll learn

JOINs
Investigate this case →