Task 3: Pinpoint Employee Overlap With Incidents
#3 · 3 of 8Free sampleQuestion
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.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