Lydia_HW1_Q1_5

0

Please login or register to vote for this query.

(click on this box to dismiss)

Motor Vehicle Maintenance and Repair Meta

Q&A about the site for mechanics and DIY enthusiast owners of cars, trucks, and motorcycles

SELECT YEAR(CreationDate) AS Year, 
MONTH(CreationDate) AS Month,
PostTypeId, COUNT(Id) AS cnt
FROM Posts
GROUP BY YEAR(CreationDate), MONTH(CreationDate), PostTypeId

Enter Parameters

Options:
Switch to main site
loading Hold tight while we fetch your results