-- Creating filter columns based on the genre hits
ALTER TABLE PortfolioProject.dbo.Goodreads
ADD genre_fantasy NVARCHAR(255),
    genre_romance NVARCHAR(255),
    genre_young_adult NVARCHAR(255),
    genre_paranormal NVARCHAR(255),
    genre_classics NVARCHAR(255),
    genre_science_fiction NVARCHAR(255),
    genre_mystery NVARCHAR(255),
    genre_childrens NVARCHAR(255),
    genre_adventure NVARCHAR(255);