Practice · 1 of 2

CRUD the Hard Way

CHALLENGE

Difficulty: intermediate+25 XP

Implement setup(conn) that creates table items(id INTEGER PRIMARY KEY, name TEXT NOT NULL, qty INTEGER NOT NULL DEFAULT 0), and restock(conn, name, qty) inserting a row and returning its id.

Press Submit to check your solution.

Back to lesson: Practice: SQL Drills