SQLite inventory report
Use a small synthetic SQLite inventory to report items below a practice stock threshold. Explain which rows are included and test a boundary quantity.
Requirements
- Join item and stock information using a key.
- Filter below the chosen threshold and sort the result.
- Use only resettable synthetic practice data.
Expected behaviours
- The example runs in the platform runtime without an external package.
- The output communicates the stated purpose using fictional sample data.
- The learner can describe one limitation and one next improvement.