-- Ordering the columns, filtering out low rating counts and missing isbn rows and non-sci-fi books
SELECT id, isbn, rating_100, rating_count, numberofreviews, title, author, publishing_year, genre_science_fiction
FROM PortfolioProject.dbo.Goodreads
WHERE genre_science_fiction ='Yes' AND rating_count > 30 AND isbn IS NOT NULL
ORDER BY rating DESC