Column constraints - NOT NULL and UNIQUE

CREATE TABLE books (
                      id INTEGER,
                      name TEXT UNIQUE NOT NULL,
                      price REAL
                   );

CREATE TABLE books (
                      id INTEGER,
                      name TEXT UNIQUE NOT NULL,
                      price REAL
                   );
INSERT INTO books VALUES (1, NULL, 333.30);

CREATE TABLE books (
                      id INTEGER,
                      name TEXT UNIQUE NOT NULL,
                      price REAL
                   );
INSERT INTO books VALUES (1, 'Basics of JavaScript', 333.30);
INSERT INTO books VALUES (2, 'Basics of JavaScript', 450.50);