0

Please login or register to vote for this query.

(click on this box to dismiss)

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;

fork query

edited aug 8 13

created aug 8 13 anonymous