stats about a user's answers

0

Please login or register to vote for this query.

(click on this box to dismiss)

Computational Science Meta

Q&A about the site for scientists using computers to solve scientific problems

select OwnerUserId, sum(CommentCount) as s_CommentCount, 
sum(Score) as s_Score
From Posts
--where ParentId IS NULL
where PostTypeId = 2
and OwnerUserId in (953140,276052,418556,1357341,829571,157882,1061426,2494652,203907,12960,131872,33203,238134,130758,4316,2213023,2648,37213,767843,3474,1831293,1093528,63051,342235,1876342,1127571,522444,892029,1441485,44330,1815873,2534090,571407,260990,40342,22656,2314073,913543,869736,2333145,992484,1103872,2515106,1671066,16883,2164109,20400,542091,70604,57695,276101,1237040,871026,1707091,11236,1679863,2017866,939,147601,2444921,2529549,16050,21234,2506927,2218281,139985,1927832,1163607,230513,2190298,1981279,157027,187141,953140,276052,418556,1357341,829571,157882,1061426,2494652,203907,12960,131872,33203,238134,130758,4316,2213023,2648,37213,767843,3474,1831293,1093528,63051,342235,1876342,1127571,522444,892029,1441485,44330,1815873,2534090,571407,260990,40342,22656,2314073,913543,869736,2333145,992484,1103872,2515106,1671066,16883,2164109,20400,542091,70604,57695,276101,1237040,871026,1707091,11236,1679863,2017866,939,147601,2444921,2529549,16050,21234,2506927,2218281,139985,1927832,1163607,230513,2190298,1981279,157027,187141)
group by OwnerUserId;

Enter Parameters

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