requests.sql

-- QUIZZ DB & ActiveRecord
-- Q1 A bunch of tables contining data connected between each other through a system of primary(id)/foreign keys(xxxxx_id)
-- Q2 1:N
--    N:N
--    1:1
-- Q5 SQL
-- Q6
SELECT *
FROM books
WHERE publishing_year < 1985
-- Q7
SELECT b.id, b.title, b.publishing_year
FROM books b
JOIN authors a ON a.id = b.author_id
WHERE a.name = 'Jules Verne'
ORDER BY b.publishing_year DESC
LIMIT 3