Task 2: Track Unauthorized Access Logs
#2 · 2 of 8Free sampleQuestion
Task 2: Track Unauthorized Access Logs
List the
lab_id, incident_type, and count of unauthorized access incidents for each lab.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