0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for users of TeX, LaTeX, ConTeXt, and related typesetting systems

--select count(u.id) from users where 
select count(u.id)/count(p.id) from users u left join posts p on u.id=p.owneruserid where p.id is not null-- group by u.id;
--select top 10 u.id from users u where (DATEDIFF (day , u.creationdate, getdate() ))>563 order by displayname;
--select avg(DATEDIFF (day , u.creationdate, getdate() )) from users u left join posts p on u.id=p.owneruserid where p.id is null;
--select top 10 CreationDate from Users order by CreationDate asc;

view current version

edited mar 17 14

created mar 17 14 jon.doe13291