-- Updating the missing values to read as NULL
UPDATE PortfolioProject.dbo.Goodreads SET isbn = NULL WHERE isbn ='None';
UPDATE PortfolioProject.dbo.Goodreads SET media_type = NULL WHERE media_type ='None';
UPDATE PortfolioProject.dbo.Goodreads SET author_url = NULL WHERE author_url ='None';
UPDATE PortfolioProject.dbo.Goodreads SET title = NULL WHERE title='None';
UPDATE PortfolioProject.dbo.Goodreads SET genres = NULL WHERE genres='None';

-- Clearing the rows where most of the data is missing
DELETE FROM PortfolioProject.dbo.Goodreads WHERE media_type is null