Q&A about the site for software engineers working on automated testing, continuous delivery, service integration and monitoring, and building SDLC infrastructure
--DECLARE @delimiter nvarchar(255) = '>'; --SELECT Id, CreationDate, Tags --FROM Posts --CROSS APPLY STRING_SPLIT(Tags, @delimiter) AS SepTags --WHERE YEAR(CreationDate) = 2017 --ORDER BY Id SELECT Views, COUNT(*) FROM Users GROUP BY Views