Q&A for committed Christians, experts in Christianity and those interested in learning more
select Id as [Post Link], Score, ViewCount, round(convert(decimal,ViewCount)/2500,2) as [% Notable], round(convert(decimal,ViewCount)/10000,2) as [% Famous], Case when AcceptedAnswerId is null then 'No' else 'Yes' end as AcceptedAnswer from posts where OwnerUserId = ##UserId## and PostTypeId = 1 order by ViewCount Desc