select sum (q.viewcount) from posts as q join posts as a ...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

select sum (q.viewcount) 
from posts as q
join posts as a
  on a.parentid = q.id
where a.owneruserid = 126897
and a.creationdate between '2018-04-01' and '2019-04-01'
and a.posttypeid = 2
and q.posttypeid = 1;

select count(distinct q.id) 
from posts as q
join posts as a
  on a.parentid = q.id
where a.owneruserid = 126897
and a.creationdate between '2018-04-01' and '2019-04-01'
and a.posttypeid = 2
and q.posttypeid = 1
and q.AcceptedAnswerId = a.id;

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results