Q&A about the site for members of the workforce navigating the professional setting
select TOP 500 Id as [Post Link], ViewCount, CAST(CONVERT(INT, CAST(ViewCount as float) / 10) as VARCHAR(5)) + '%' as Popular, CAST(CONVERT(INT, CAST(ViewCount as float) / 25) as VARCHAR(5)) + '%' as Notable, CAST(CONVERT(INT, CAST(ViewCount as float) / 100) as VARCHAR(5)) + '%' as Famous FROM Posts WHERE PostTypeId=1 and OwnerUserId=##UserID:int## ORDER BY ViewCount DESC