-- Exploring the most popular tags in the genres column
SELECT TOP 100
	value [word],
	COUNT(*) [#times]
FROM  PortfolioProject.dbo.Goodreads
CROSS APPLY STRING_SPLIT(Goodreads.genres, '|') 
GROUP BY value
ORDER BY COUNT(*) DESC