Task 1: Identify Labs With High Security Incidents
#1 · 1 of 8Free sampleQuestion
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.Tables6 tables · 25 columns
Tables
6 tables · 25 columnslabs4 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
Loading the practice editor and dataset…
Sign up to unlock
The reference answer is one click away.
Free account unlocks the reference answer, the explanation, and the GPT tutor on every exercise in the library.
- Reference answer + explanation revealed after each attempt
- GPT tutor for every problem
- Progress saved on the platform
- 1,598 graded exercises
- Free forever — no credit card