#020Level 3 of 6 · Scenario 4: Provenance
No paperwork at all
Scenario 4 · Provenance
An object with no transfer records has no documented history — nothing saying where it came from or who had it before us. Those are the ones a due-diligence review starts with, and nobody knows how many there are.
Schema · 3 tables
owners
- idpkINTEGER
- nameVARCHAR
- countryVARCHAR
objects
- idpkINTEGER
- titleVARCHAR
- wingVARCHAR
- current_owner_idINTEGER
transfers
- idpkINTEGER
- object_idINTEGER
- seqINTEGER
- from_owner_idINTEGER
- to_owner_idINTEGER
- transferred_onDATE
- document_refVARCHAR
Toolkit
- SELECT
- Choose which columns come back.
- FROM
- Specify which table to read.
- WHERE
- Filter rows by a condition.
- ORDER BY
- Sort the results by a column.
- IS NULL
- Test whether a value is missing.
- LEFT JOIN
- Keeps every row from the first table.
- ON
- The condition the two tables match on.
Objective
Return the title of every object with no rows at all in the transfers table, alphabetically.
Your query
⌘ ⏎
Results
No result yet.