veekaybee/enriched_data.md

Created June 30, 2023 09:51

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/veekaybee/fa82d589d511dd5978c3020a8a85be27.js"></script>
Save veekaybee/fa82d589d511dd5978c3020a8a85be27 to your computer and use it in GitHub Desktop.

Raw

how to properly select from DuckDB

SELECT review_text,title,description,goodreads.average_rating, goodreads_authors.name 
FROM goodreads 
JOIN goodreads_reviews 
ON goodreads.book_id = goodreads_reviews.book_id 
JOIN goodreads_authors  
ON goodreads_authors.author_id = (select REGEXP_EXTRACT(authors, '[0-9]+')[1] as author_id FROM goodreads) LIMIT 10;