0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for builders and users of networked sensors and control devices in the contexts of smart homes, industry automation, or environmental sensors

SELECT q.Id as id, q.Title as title,  
        q.CreationDate as creation_date, q.Tags as tags, q.Body as body, 
          min(a.CreationDate) as first_ans_dt  
       FROM posts q 
           LEFT JOIN posts a 
           ON q.Id=a.ParentId AND q.CreationDate>='2020-03-01' and q.CreationDate<'2020-05-01'  
       AND  a.CreationDate>='2020-03-01' and a.CreationDate<'2020-05-01'   
       WHERE  q.CreationDate>='2020-03-01' and q.CreationDate<'2020-05-01'  
       AND  a.CreationDate>='2020-03-01' and a.CreationDate<'2020-05-01' 
       GROUP BY q.Id, q.Title,  q.CreationDate, q.Tags, q.Body

fork query

edited aug 11

created aug 11 anonymous