010:28JupyterLiteBeginner
Open JupyterLite and run your first line
You open a Python notebook in your browser, with no account and nothing to install, and run your first cell.
Catalogue · First steps in Python and SQL, with AI
Filter and sort in SQL
You find in SQL the products below their reorder point, sorted by stock.
JupyterLiteBeginner0:25Capsule 9 of 12
SkillKapsul
Space: play · ← →: 5 seconds · M: sound · F: full screen
The steps
The exact sequence, in order.
- 01
Type SELECT product, warehouse, stock, reorder_point
- 02
Then FROM inventory
- 03
Then WHERE stock < reorder_point
- 04
Then ORDER BY stock; and Shift + Enter: two rows, the Atlas Refill.
The habit to keep
One clause per line: it’s easier to read back.
Related capsules
You might also like
Newsletter
Monday's capsule
One skill a week, straight to your inbox. The easiest way to keep learning without thinking about it.
Your data stays in the EU. Never sold.