#003Level 3 of 6 · Scenario 1: The Ashcombe Bequest
What the lab can take
Scenario 1 · The Ashcombe Bequest
Conservation has one bench free this month. They will take something unstable and worth saving — not every chipped frame in the bequest.
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.
- AND
- Require two conditions to both be true.
Objective
Return the title and valuation for objects in unstable condition valued over 10000, highest first.
Your query
⌘ ⏎
Results
No result yet.