book_sql.sql

SELECT
review_text,
goodreads_auth_ids.title,
link,
goodreads_auth_ids.description,
goodreads_auth_ids.average_rating,
goodreads_authors.name AS author,
text_reviews_count,
review_text || goodreads_auth_ids.title || goodreads_auth_ids.description
|| goodreads_authors.name as sentence
FROM goodreads_auth_ids
JOIN goodreads_reviews
ON goodreads_auth_ids.book_id = goodreads_reviews.book_id
JOIN goodreads_authors
ON goodreads_auth_ids.author_id = goodreads_authors.author_id
WHERE goodreads_auth_ids.author_id NOT ILIKE ''