#006Level 6 of 6 · Scenario 1: The Ashcombe Bequest
The mislabelled treatment
Scenario 1 · The Ashcombe Bequest
Conservation finished a treatment last week and logged it against a title that does not exist in the registry — somebody typed the label from memory. The bench notes do carry two facts that are certainly right: the object came from Ravensworth, and it was received on the same day as the Regency Mantel Clock. The registrar wants it identified before the invoice goes out.
Schema · 2 tables
sources
- idpkINTEGER
- nameVARCHAR
- contactVARCHAR
- countryVARCHAR
objects
- idpkINTEGER
- source_id→ sourcesINTEGER
- titleVARCHAR
- valuationDOUBLE
- received_onDATE
- conditionVARCHAR
- noteVARCHAR
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.
- DESC
- Reverse the sort: largest or latest first.
- LIKE
- Match text against a pattern, with % standing for anything.
- AND
- Require two conditions to both be true.
Objective
Work out which object conservation actually treated, and enter its title. Run as many queries as you need — nobody is counting.
Your query
⌘ ⏎
The object they treated
Results
No result yet.