data.sql

INSERT INTO book (title, author, published_date)
VALUES ('The Silent Patient', 'Alex Michaelides', '2019-02-05'),
       ('Where the Crawdads Sing', 'Delia Owens', '2018-08-14'),
       ('The Midnight Library', 'Matt Haig', '2020-09-29'),
       ('The Night Circus', 'Erin Morgenstern', '2011-09-13'),
       ('Project Hail Mary', 'Andy Weir', '2021-05-04'),
       ('The Book Thief', 'Markus Zusak', '2005-03-14'),
       ('The Giver of Stars', 'Jojo Moyes', '2019-10-03'),
       ('A Man Called Ove', 'Fredrik Backman', '2012-08-27'),
       ('Daisy Jones & The Six', 'Taylor Jenkins Reid', '2019-03-05'),
       ('The Rosie Project', 'Graeme Simsion', '2013-10-01'),
       ('Circe', 'Madeline Miller', '2018-04-10'),
       ('The House in the Cerulean Sea', 'TJ Klune', '2020-03-17'),
       ('Before We Were Strangers', 'Renée Carlino', '2015-08-18'),
       ('It Ends With Us', 'Colleen Hoover', '2016-08-02'),
       ('Verity', 'Colleen Hoover', '2018-12-07'),
       ('Malibu Rising', 'Taylor Jenkins Reid', '2021-06-01'),
       ('The Seven Husbands of Evelyn Hugo', 'Taylor Jenkins Reid', '2017-06-13'),
       ('The Night Watchman', 'Louise Erdrich', '2020-03-03'),
       ('The Paper Palace', 'Miranda Cowley Heller', '2021-07-06'),
       ('The 5th Wave', 'Rick Yancey', '2013-05-07'),
       ('The Shadow of the Wind', 'Carlos Ruiz Zafón', '2001-04-01'),
       ('Anxious People', 'Fredrik Backman', '2019-09-19'),
       ('The Chain', 'Adrian McKinty', '2019-07-09'),
       ('Mexican Gothic', 'Silvia Moreno-Garcia', '2020-06-30'),
       ('The Paris Library', 'Janet Skeslien Charles', '2021-02-09'),
       ('The Nightingale', 'Kristin Hannah', '2015-02-03'),
       ('The Alice Network', 'Kate Quinn', '2017-06-06'),
       ('The Huntress', 'Kate Quinn', '2019-02-26'),
       ('The Tattooist of Auschwitz', 'Heather Morris', '2018-01-11'),
       ('Cilka’s Journey', 'Heather Morris', '2019-10-01'),
       ('Beneath a Scarlet Sky', 'Mark Sullivan', '2017-05-01'),
       ('The Light We Lost', 'Jill Santopolo', '2017-02-07'),
       ('The Girl with the Louding Voice', 'Abi Daré', '2020-02-04'),
       ('American Dirt', 'Jeanine Cummins', '2020-01-21'),
       ('The Dutch House', 'Ann Patchett', '2019-09-24'),
       ('The Night Watch', 'Sergei Lukyanenko', '1998-01-01'),
       ('Recursion', 'Blake Crouch', '2019-06-11'),
       ('Dark Matter', 'Blake Crouch', '2016-07-26'),
       ('The Warehouse', 'Rob Hart', '2019-08-20'),
       ('The Institute', 'Stephen King', '2019-09-10'),
       ('Fairy Tale', 'Stephen King', '2022-09-06'),
       ('11/22/63', 'Stephen King', '2011-11-08'),
       ('The Outsider', 'Stephen King', '2018-05-22'),
       ('Later', 'Stephen King', '2021-03-02'),
       ('The Night Fire', 'Michael Connelly', '2019-10-22'),
       ('The Law of Innocence', 'Michael Connelly', '2020-11-10'),
       ('The Lincoln Lawyer', 'Michael Connelly', '2005-10-03'),
       ('The Stranger', 'Albert Camus', '1942-06-01'),
       ('Crime and Punishment', 'Fyodor Dostoevsky', '1866-01-01'),
       ('The Brothers Karamazov', 'Fyodor Dostoevsky', '1880-11-01'),
       ('War and Peace', 'Leo Tolstoy', '1869-01-01'),
       ('Anna Karenina', 'Leo Tolstoy', '1878-01-01'),
       ('The Great Gatsby', 'F. Scott Fitzgerald', '1925-04-10'),
       ('To Kill a Mockingbird', 'Harper Lee', '1960-07-11'),
       ('Pride and Prejudice', 'Jane Austen', '1813-01-28'),
       ('1984', 'George Orwell', '1949-06-08'),
       ('Brave New World', 'Aldous Huxley', '1932-08-01'),
       ('Fahrenheit 451', 'Ray Bradbury', '1953-10-19'),
       ('Slaughterhouse-Five', 'Kurt Vonnegut', '1969-03-31'),
       ('One Hundred Years of Solitude', 'Gabriel García Márquez', '1967-05-30'),
       ('Love in the Time of Cholera', 'Gabriel García Márquez', '1985-01-01'),
       ('Norwegian Wood', 'Haruki Murakami', '1987-09-04'),
       ('Kafka on the Shore', 'Haruki Murakami', '2002-09-12'),
       ('The Wind-Up Bird Chronicle', 'Haruki Murakami', '1994-04-12');