Code Lab BetaBUILD. RUN. DISCOVER.
Code Lab is in development. New lessons and improvements are on the way. Progress can be deleted.
Loading…
Code Lab is in development. New lessons and improvements are on the way. Progress can be deleted.
Loading…
Code Lab is in development. New lessons and improvements are on the way. Progress can be deleted.
SQL / POSTGRESQL / Learn / LESSON 10
Capstone: combine INSERT, UPDATE, and DELETE to maintain stock. Use WHERE carefully. Multiple statements are allowed; the final items state is checked.
Small example:
DELETE FROM items WHERE qty = 0; UPDATE items SET qty = qty + 1 WHERE category = 'tools'; INSERT INTO items (id, name, category, qty, price) VALUES (80, 'Spare', 'tools', 1, 1.00);
Starting tables for this task. Grading checks final state on other datasets too.
| id | name | category | qty | price |
|---|---|---|---|---|
| 1 | Pen | tools | 10 | 1.5 |
| 2 | Notebook | books | 5 | 3 |
| 3 | Mug | home | 2 | 8 |
| 4 | Sticker | NULL | 0 | 0.5 |
| 5 | Lamp | home | 1 | 25 |
| 6 | Book Atlas | books | 3 | 12 |
Expected verify columns: id, name, category, qty, price · row order is checked
Expected final state (displayed data):
Loading…Capstone: combine INSERT, UPDATE, and DELETE to maintain stock. Use WHERE carefully. Multiple statements are allowed; the final items state is checked.
QUERY STANDBY
›