Sql - StackExchange

data.sql

--  Get Question Id, title and Body
select Q.Id, Q.Title, G.Body 
	from 
		Posts as G, 
		(select * from Posts 
			where ParentId is null 
				and Title like 'How to%' or Title like 'how to%')
		 as Q 
	where G.ParentId = Q.Id
	
-- Questions with more than 5 answers
select Q.Id as QId, Q.Title as QTitle, Q.body as QBody, G.Id as GId, G.Body as GBody, Q.Score as QScore, G.Score as GScore,
        Q.ViewCount as QViewCount, G.ViewCount as GViewCount, Q.Tags as QTags, G.Title as GTitle 
    from 
        Posts as G, 
        (select * from Posts 
            where ParentId is null 
            and AnswerCount>=5)
         as Q
    where G.ParentId = Q.Id
    
-- Not required to know	
Select 'Data.StackExchange' As [DatabaseName], Q.Id, G.Body From [Data.StackExchange].dbo.[Posts] as G,
         ( select * From [Data.StackExchange].Posts where ParentId is null
         ) as Q 
         where G.ParentId = Q.Id UNION ALL                                                           
Select 'master' As [DatabaseName], Q.Id, G.Body From [master]..Posts as G,
         ( select * From [master]..Posts where ParentId is null
         ) as Q 
         where G.ParentId = Q.Id