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

/*
select TOP 100 YEAR(CreationDate) from Posts where PostTypeId = 1

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
*/


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

fork query

edited feb 27

created feb 27 anonymous