select SUM(p1.Score) from Posts p1 join ( select * from P...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Anime and Manga

Q&A for anime and manga fans

select SUM(p1.Score)
from Posts p1
join (
  select * from Posts
  where ParentId is null
  and Tags like '%<pandas>%') p2 on p1.ParentId = p2.Id
where p1.score = 1
and p1.CreationDate > '2014-12-31'
and p1.CreationDate < '2017-01-01'
and p1.ParentId is not null
and p1.body like '%read_csv%'

-- select Id from Posts where ViewCount > 3000000 and p2.Tags like '%<pandas>%'

Enter Parameters

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