-- Standardising the ratings column ALTER TABLE PortfolioProject.dbo.Goodreads ADD rating_100 float; UPDATE PortfolioProject.dbo.Goodreads SET rating_100 = rating * 20
-- Standardising the ratings column ALTER TABLE PortfolioProject.dbo.Goodreads ADD rating_100 float; UPDATE PortfolioProject.dbo.Goodreads SET rating_100 = rating * 20