Q&A about the site for practitioners, researchers, and students in cognitive science, psychology, neuroscience, and psychiatry
--select top 100 * from posts; /*select posttypes.name, count(*) from posttypes inner join posts on posts.posttypeid=posttypes.id where posttypes.name in ('Question', 'Answer') group by posttypes.name;*/ /*select top 1 postID, count(distinct(revisionguid))as counter from PostHistory group by postid order by counter desc;*/ --select min(age) as min_age, max(age) as max_age from Users; /*select age, count(*) as count from Users group by age order by count desc;*/ /*select count(*) from badges inner join users on badges.userid = users.id where users.displayname = 'Jon Skeet';*/ select tagname, count from tags order by count desc;