Delete Expired Sessions

-- Drill 16 — حذف الجلسات المنتهية بـ DELETE — SQLite 3.x+
CREATE TABLE sessions (
  id INTEGER PRIMARY KEY,
  expired INTEGER NOT NULL
);

INSERT INTO sessions VALUES
  (1, 0),
  (2, 1),
  (3, 1);

DELETE FROM sessions
WHERE expired = 1;

SELECT COUNT(*) AS remaining_sessions
FROM sessions;