#001Level 1 of 6 · Scenario 1: The Ashcombe Bequest
The insurance schedule
Scenario 1 · The Ashcombe Bequest
Forty crates came in on Friday and the insurer will not cover a single one until the high-value pieces are scheduled separately. Anything over 50,000 needs its own line.
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.
Objective
Return the title and valuation for every object valued over 50000, highest first.
Your query
⌘ ⏎
Results
No result yet.