Questions Count by Month

0

Please login or register to vote for this query.

(click on this box to dismiss)

スタック・オーバーフロー

プログラマーとプログラミングに熱心な人々のための質問と回答

SELECT date1, count(id) as count
FROM (

  SELECT 
    FORMAT (p.CreationDate, 'yyyy') as [date1],
    (p.Id) as id
  FROM Posts p
    
  WHERE
    p.PostTypeId = 1  -- 1=Question
    
  ) as t1
group by date1
order by date1

Enter Parameters

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