#002Level 2 of 6 · Scenario 1: The Ashcombe Bequest
Three for the strongroom
Scenario 1 · The Ashcombe Bequest
There is room in the strongroom for three pieces tonight and the rest go in the general store. Security wants a list, not a discussion.
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.
- LIMIT
- Stop after a set number of rows.
Objective
Return the title and valuation for the three most valuable objects, highest first.
Your query
⌘ ⏎
Results
No result yet.