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

# SELECT
`SELECT last_name,first_name FROM students WHERE student_id LIKE '%123%';`

# INSERT
`INSERT INTO students (name, email, cohort) VALUES ('Harper', 'harper@example.org', 12);`

# UPDATE
`UPDATE students SET last_name = 'Jones' WHERE student_id = 123;`

# ORDER BY
`SELECT last_name,first_name FROM students ORDER BY last_name, first_name DESC;`

# LIKE
`SELECT last_name FROM students WHERE last_name LIKE '%son';`

# DELETE
`DELETE FROM students WHERE last_name = 'Smith';`