instruction: Investigating the utility of getting Informed.
response: SELECT SUM(CASE WHEN b.Id IS NULL THEN 1 ELSE 0 END) AS Nuninf, SUM(CASE WHEN NOT b.Id IS NULL THEN 1 ELSE 0 END) AS Ninf, SUM(CASE WHEN b.Id IS NULL THEN p.Score ELSE 0 END) * 1.0 / SUM(CASE WHEN b.Id IS NULL THEN 1 ELSE 0 END) AS AvgScoreUninf, SUM(CASE WHEN NOT b.Id IS NULL THEN p.Score ELSE 0 END) * 1.0 / SUM(CASE WHEN NOT b.Id IS NULL THEN 1 ELSE 0 END) AS AvgScoreInf FROM Posts AS p LEFT OUTER JOIN Badges AS b ON b.UserId = p.OwnerUserId AND b.Name = 'Informed' AND b.Date < p.CreationDate