PRIMARY KEY - AUTOINCREMENT


CREATE TABLE teachers (
                        id INTEGER PRIMARY KEY AUTOINCREMENT,
                        name TEXT NOT NULL,
                        department TEXT
                      );
INSERT INTO teachers (name, department) VALUES
                                        ('Marcus', 'Ruby'),
                                        ('Jofra', 'SQL'),
                                        ('Kagiso', 'JavaScript');
