Loading this exercise…

Task 3: Pinpoint Employee Overlap With Incidents

#3 · 3 of 8Free sample

Instructions

Task 3: Pinpoint Employee Overlap With Incidents

Identify employees whose work shifts overlap with at least 3 unauthorized access incidents. Retrieve employee_id, name, and number of overlapping incidents.

Loading the practice editor and dataset…

Sign up to unlock

The reference answer is one attempt away.

Create a free account to save your progress and reveal the worked answer for this free exercise. The complete practice library is available with Practice Pass or Mastery.

Save attempts and completed exercises
Reveal this free exercise's answer after an attempt
Return to your progress from any device
Free forever — no credit card

Create free account →Already a member? Log in →

Task 4: Investigate Resource Consumption

All exercises in Zombie Virus – Part 1: Stopping the Release

severity

TEXT

timestampTEXT

employees3 cols

employee_idINTEGER
nameTEXT
lab_idINTEGER

work_shifts5 cols

shift_idINTEGER
employee_idINTEGER
lab_idINTEGER
start_timeTEXT
end_timeTEXT

shipments4 cols

shipment_idINTEGER
lab_idINTEGER
statusTEXT
timestampTEXT

district_usage4 cols

lab_idINTEGER
resource_typeTEXT
quantity_usedINTEGER
dateTEXT