-- Examining the table for null values
SELECT COUNT(*)-COUNT(rating) AS rating
	 , COUNT(*)-COUNT(numberofreviews) AS n_of_reviews
	 , COUNT(*)-COUNT(isbn) AS isbn
	 , COUNT(*)-COUNT(publishing_year) AS publishing_year
	 , COUNT(*)-COUNT(genres) AS genres
	 , COUNT(*)-COUNT(rating_count) AS rating_count
	 , COUNT(*)-COUNT(title) AS title
FROM PortfolioProject.dbo.Goodreads;