Lab - Problem 10

SELECT a.Content as [Answer Content], q.Title as Question, c.Name as Category
FROM Answers a
JOIN Questions q ON q.Id = a.QuestionId
JOIN Categories c ON c.Id = q.CategoryId
WHERE
    YEAR(a.CreatedOn) = (SELECT MAX(YEAR(a.CreatedOn)) FROM Answers a)
    AND
    a.IsHidden = '1'
    AND
    (MONTH(a.CreatedOn) = (SELECT MIN(MONTH(a.CreatedOn)) FROM Answers a)
    OR
    MONTH(a.CreatedOn) = (SELECT MAX(MONTH(a.CreatedOn)) FROM Answers a))
ORDER BY c.Name