HomeWork3

0

Please login or register to vote for this query.

(click on this box to dismiss)

Robotics Meta

Q&A about the site for professional robotic engineers, hobbyists, researchers and students

select count(Id) from Users where year(CreationDate) = 2015;
select count(Id) from Users where Location like  'Germany';
select count(Id), Location from Users group by Location;
select DisplayName, count(Posts.OwnerUserId) from (select  top 10 *  from Users order by Reputation desc) Z  left join Posts on Z.Id=Posts.OwnerUserId group by DisplayName;

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results