0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for project managers

select a.*,b.* from (
(select
*
from
Posts
where
PostTypeId=1 and
Tags like '%python%') a
join
(select
ParentId,
min(CreationDate) as first_response
from
Posts
where PostTypeId=2
group by ParentId
) b on a.Id = b.ParentId
)

view current version

edited feb 23 19

created feb 23 19 anonymous