Loading this exercise…

Task 1: List Missing Artifacts

#1 · 1 of 10Free sample

Instructions

Task 1: List Missing Artifacts

Using the artifacts and inventory_logs tables, find the artifacts that are currently 'checked_out' (i.e. artifacts whose latest log action is 'checked_out' and have not been returned). Return the following columns: artifact_id and artifact_name.

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 →

Task 2: Staff Vault Access

Tables

8 tables · 35 columns

artifacts5 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