/* //Comparing questions amount - with bounty, without a...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Interpersonal Skills

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 TOP 100 Score, ClosedDate, DeletionDate   from Posts where AnswerCount = 0 and PostTypeId = 1 
and YEAR(CreationDate) = 2020 and LEN (Body) > 200

Enter Parameters

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