Task 2: Staff Vault Access
#2 · 2 of 10Free sampleQuestion
Task 2: Staff Vault Access
Using the
security_logs and inventory_logs tables, identify staff members who accessed the Vault within 15 minutes before or after an artifact was checked out (which may indicate suspicious activity during potential theft timelines). Return the following columns from the security logs: person_id, role, and the access timestamp (labeled as access_timestamp).Tables8 tables · 35 columns
Tables
8 tables · 35 columnsartifacts5 cols
- artifact_idINTEGER
- artifact_nameTEXT
- origin_yearINTEGER
- valueINTEGER
- current_locationTEXT
exhibits2 cols
- exhibit_idINTEGER
- exhibit_nameTEXT
staff3 cols
- staff_idINTEGER
- staff_nameTEXT
- roleTEXT
visitors4 cols
- visitor_idINTEGER
- visitor_nameTEXT
- originTEXT
- purposeTEXT
security_logs6 cols
- log_idINTEGER
- person_idINTEGER
- roleTEXT
- locationTEXT
- actionTEXT
- timestampTEXT
inventory_logs4 cols
- log_idINTEGER
- artifact_idINTEGER
- actionTEXT
- timestampTEXT
artifact_movement_logs5 cols
- movement_idINTEGER
- artifact_idINTEGER
- from_locationTEXT
- to_locationTEXT
- timestampTEXT
interaction_logs6 cols
- interaction_idINTEGER
- person_idINTEGER
- roleTEXT
- artifact_idINTEGER
- locationTEXT
- timestampTEXT
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