sample.sql

CREATE TABLE books (
  id              SERIAL PRIMARY KEY,
  title           VARCHAR(100) NOT NULL,
  primary_author  VARCHAR(100) NULL
);

SELECT * FROM books WHERE title = 'goosebumps'

INSERT INTO books(title,  author) VALUES
 ('goosebumps', 'R. L. Stine');

 INSERT INTO books(title,  primary_author) VALUES
 ('animorphs', 'K. A. applegate');

INSERT INTO books(title,  primary_author) VALUES
('baby sitters club', 'Anne Martin');


UPDATE books SET title = 'Animorphs' WHERE id = 2;

ALTER TABLE books ADD COLUMN RATING INT NULL

UPDATE books SET rating = 3; 

INSERT INTO books (title, primary_author, rating) 
    VALUES ('Harry Potter', 'JK Rowling', 4 );