Insert Lessons

-- Drill 03 — إدراج دروس وعرضها مرتبة — SQLite 3.x+
CREATE TABLE lessons (
  id INTEGER PRIMARY KEY,
  course_slug TEXT NOT NULL,
  title TEXT NOT NULL,
  weight INTEGER NOT NULL
);

INSERT INTO lessons (course_slug, title, weight)
VALUES
  ('sql', 'SELECT Basics', 1),
  ('sql', 'Filtering Rows', 2),
  ('sql', 'Joining Tables', 3);

SELECT title
FROM lessons
ORDER BY weight;