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.
Course projects