basic_queries.sql

-- BASIC QUERIES
-- Unless otherwise stated, all queries should return all columns

-- Get all information about all authors

-- Get just the name and birth year of all authors

-- Get all authors born in the 20th centruy or later

-- Get all authors born in the USA

-- Get all books published on 1985

-- Get all books published before 1989

-- Get just the title of all books.

-- Get just the year that 'A Dance with Dragons' was published
  -- Cry when you realize how long it's been

-- Get all books which have `the` somewhere in their title (hint, look up LIKE/ILIKE)

-- Add yourself as an author

-- Add two books that you'd like to write (you can hard-code your id as the author id)

-- Update one of your books to have a new title

-- Delete your books

-- Delete your author entry