Q&A for professional and enthusiast programmers
select SUM(p.HasRadsLink) as [Posts With rads Redirect Links], SUM(p.HasAmazonLink) as [Posts With Amazon Links] from (select top 100000 r.* from (select q.*, SIGN(CHARINDEX('rads.stackoverflow.com', q.Body)) as HasRadsLink, SIGN(CHARINDEX('www.amazon.com', q.Body)) as HasAmazonLink from Posts q ) r order by r.Id asc) p