Loading this exercise…

Task 1: Identify Labs With High Security Incidents

#1 · 1 of 8Free sample

Instructions

Task 1: Identify Labs With High Security Incidents

Retrieve the lab_id and count of high-severity security incidents for each lab. Include only labs with 3 or more high-severity 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 →

Tables

6 tables · 25 columns

labs4 cols

lab_idINTEGER
lab_nameTEXT
cityTEXT
statusTEXT

security_logs5 cols

log_idINTEGER
lab_idINTEGER
incident_typeTEXT
severityTEXT
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