0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for people looking to improve their interpersonal communication skills

/*

//Comparing questions amount - with bounty, without answer, all
select COUNT(DISTINCT(PostId)) from Votes where BountyAmount > 0
UNION 
select COUNT(*) from Posts where AnswerCount = 0 and PostTypeId = 1
UNION 
select COUNT(*) from Posts where AnswerCount = 0 and CommentCount = 0 and  PostTypeId = 1
UNION 
select COUNT(*) from Posts where PostTypeId = 1


//Count questions without answers
select COUNT(*) from Posts where AnswerCount = 0 and PostTypeId = 1 
and YEAR(CreationDate) = 2020 and LEN (Body) > 200
*/


select COUNT(*) from Posts where 
AnswerCount = 0 and 
PostTypeId = 1 and 
DeletionDate IS NULL and
ClosedDate IS NULL and
Score > 0 and
YEAR(CreationDate) = 2020 
and LEN (Body) > 200

fork query

edited feb 27

created feb 27 anonymous