Q&A for professional and enthusiast programmers
select a.Id as [Post Link], a.Tags, d.DisplayName, d.Reputation,
(select count(*) from Badges where UserId = a.OwnerUserId) as AskerBadges,
a.CreationDate, e.DisplayName, e.Reputation,
(select count(*) from Badges where UserId = b.OwnerUserId) as AnswererBadges
from Posts a
inner join Posts b on b.ParentId=a.Id
inner join Users d on d.Id=a.OwnerUserId
inner join Users e on e.Id=b.OwnerUserId
where a.PostTypeId=1 and a.Tags like '%android%'
and a.CreationDate between '2008-03-01 00:00:00' and '2013-03-01 00:00:00'
order by a.Id