with p2016 as ( select OwnerUserId, min(posts.CreationDat...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

with
p2016 as (
select OwnerUserId, min(posts.CreationDate) mCD
from posts
left join users ON posts.OwnerUserId = users.id
where posts.tags like '%sql%' and users.location like '%Russia%'
group by posts.OwnerUserId
having (min(posts.CreationDate) > '2015') and (min(posts.CreationDate) < '2017')
)

select count(*)
from p2016

Enter Parameters

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