HW1

0

Please login or register to vote for this query.

(click on this box to dismiss)

Science Fiction and Fantasy

Q&A for science fiction and fantasy enthusiasts

SELECT CONVERT(VARCHAR(6),CreationDate,112) AS 'year-month', COUNT(*) AS 'count' FROM Posts
GROUP BY CONVERT(VARCHAR(6),CreationDate,112)
ORDER BY CONVERT(VARCHAR(6),CreationDate,112);

/**SELECT CONVERT(VARCHAR(6),CreationDate,112) FROM Posts;

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results