SELECT format(CreationDate,'yyyy - MM') AS 'Newdate' ,cou...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Interpersonal Skills

Q&A for people looking to improve their interpersonal communication skills

SELECT format(CreationDate,'yyyy - MM') AS 'Newdate' ,count(*) AS 'NumberofPost',
PostTypeId
FROM posts
GROUP BY format(CreationDate,'yyyy - MM'),PostTypeId
ORDER BY 'NumberofPost';

Enter Parameters

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