Q&A about the site for members of the workforce navigating the professional setting
SELECT q.id as 'qid', q.Title, q.Score as 'qscore', q.Tags as 'tags', q.LastEditDate as 'qdate', q.Body as 'question', a.id as 'aid', a.Body as 'answer', a.Score as 'ascore', a.LastEditDate as 'adate', a.FavoriteCount as 'afavoritecount', a.CommentCount as 'acommentcount'
FROM Posts q
JOIN Posts as a ON a.ParentId = q.id
JOIN Users as u ON u.id = a.OwnerUserId
q.Tags LIKE '%<tornado>%' AND