Q&A for linguists, etymologists, and serious English language enthusiasts
SELECT TOP 100 p.Id, p.ParentId, p.AcceptedAnswerId, p.CreationDate FROM ( SELECT pq.Id, pq.ParentId, pq.AcceptedAnswerId, pq.CreationDate FROM posts pq LEFT JOIN ( SELECT pa.Id, pa.ParentId, pa.AcceptedAnswerId, pa.CreationDate FROM posts as pa WHERE pa.ParentId IS NOT NULL ) pa on pa.ParentId = pq.Id ) as p order by id