HW1

0

Please login or register to vote for this query.

(click on this box to dismiss)

Joomla

Q&A for Joomla! administrators, users, developers and designers

SELECT CONVERT(VARCHAR(4),CreationDate,120) AS year, CONVERT(VARCHAR(2),CreationDate,110) AS month, 
PostTypeId, COUNT(*) AS count FROM Posts
WHERE PostTypeId=1
GROUP BY CONVERT(VARCHAR(4),CreationDate,120), CONVERT(VARCHAR(2),CreationDate,110), PostTypeId
ORDER BY count DESC;

Enter Parameters

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