#005Level 5 of 6 · Scenario 1: The Ashcombe Bequest
The two-day intake
Scenario 1 · The Ashcombe Bequest
The registrar who logged the 14th and 15th has since left, and nothing she catalogued has been checked. Pull those two days so someone can walk the shelves against them.
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.
- BETWEEN
- Match a range, including both endpoints.
Objective
Return the title, valuation and received_on for objects received from 2026-08-14 to 2026-08-15 inclusive, highest valuation first.
Your query
⌘ ⏎
Results
No result yet.