#004Level 4 of 6 · Scenario 1: The Ashcombe Bequest
The flood claim
Scenario 1 · The Ashcombe Bequest
The crates sat in a wet basement before they reached us. The insurer is building the claim and wants every object whose condition note mentions water — the surveyors each wrote it their own way.
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.
Objective
Return the title and valuation for every object whose note mentions water, highest first.
Your query
⌘ ⏎
Results
No result yet.