0

Please login or register to vote for this query.

(click on this box to dismiss)

Perguntas e respostas para programadores profissionais e entusiastas

SELECT
  count(CASE WHEN p.Score <= -1 THEN 1 END) negative,
  count(CASE WHEN p.Score = 0 THEN 1 END) zero,
  count(CASE WHEN p.Score >= 1 THEN 1 END) positive
FROM Posts p join Comments c on (p.Id = c.PostId) 
WHERE UPPER(c.Text) LIKE UPPER('%sobrevivência%')
  AND p.ClosedDate is not null

fork query

edited apr 15 20 hkotsubo

created dec 5 13 hims056