Q&A about the site for those committed to a vegan or vegetarian lifestyle and anyone interested in learning more
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