Q&A about the site for professional robotic engineers, hobbyists, researchers and students
/*select count(Id) as Users from Users; select count(Id) as Questions from Posts where PostTypeId = 1; select count(Id) as Answers from Posts where PostTypeId = 2;*/ /*select * from (select count(Id) as Users from Users) inner join (select count(Id) as Questions from Posts where PostTypeId = 1) inner join (select count(Id) as Answers from Posts where PostTypeId = 2) /*select count(Users.Id) as Users count(Posts.Id) as Questions count(Posts.Id) as Answers where PostTypeId = 1; where PostTypeId = 2;*/ select top 100 Title, Body, OwnerDisplayName from Posts where PostTypeId = 1 order by CreationDate Desc;