Loading this exercise…

Task 2: Track Unauthorized Access Logs

#2 · 2 of 8Free sample

Instructions

Task 2: Track Unauthorized Access Logs

List the lab_id, incident_type, and count of unauthorized access incidents for each lab.

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 →

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