Queries

1. Get all books from newest to oldest
===============================
SELECT
    title,
    publication_date
FROM
    books
ORDER BY
    publication_date
DESC;
===============================

2. Get the oldest book from every author
===============================
 SELECT
    title,
    first_name,
    last_name,
    publication_date
FROM
    books
LEFT JOIN authors ON books.fk_author = authors.id
ORDER BY
    publication_date ASC
LIMIT 3;

===============================
3. Get all books that have a book series
===============================
SELECT
    title,
    series
FROM
    books
LEFT JOIN series ON books.fk_series = series.id
WHERE
    series IS NOT NULL;
===============================

4. Get every author's book count
===============================
SELECT
    first_name,
    last_name,
    COUNT(books.id) AS Book_Count
FROM
    books
LEFT JOIN authors ON books.fk_author = authors.id
GROUP BY
    fk_author;
===============================