0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for folks dedicated to a lifestyle that can be maintained indefinitely without depleting available resources

Select 
sub.TagName, MAX(DATEDIFF(hour, sub.CreationDate, ps.CreationDate))
from Posts ps, (Select p.AcceptedAnswerId, p.CreationDate, t.TagName from Posts p, Tags t, PostTags pt where p.Id=pt.PostId AND t.Id=pt.TagId AND t.TagName IN 
('angular')
) as sub where ps.Id=sub.AcceptedAnswerId and DATEDIFF(hour, sub.CreationDate, ps.CreationDate)=13962
GROUP BY sub.TagName
ORDER BY sub.TagName

fork query

edited oct 18 17

created oct 17 17 anonymous