Q&A about the site for expert genealogists and people interested in genealogy or family history
/* Getting the percentage of posts that have no comments just used subqueries in the select statement*/ Select cast((select count(*) from posts where commentcount = 0) as float)/cast((select count(*) from posts) as float) *100 as percent_without_comments ;