Q&A about the site for developers and users of elementary OS and applications
SELECT distinct FORMAT (d.CreationDate, 'yyyy-MM-dd') as [date1], FORMAT (d.CreationDate, 'yyyy-MM') as [date2], (d.Id) as id, d.Title, d.Body, d.Tags, Score, AnswerCount, CommentCount, FavoriteCount FROM Posts d WHERE d.PostTypeId = 1 -- 1=Question and d.CreationDate >= '2021-03-01' and ((d.Title collate SQL_Latin1_General_CP1_CI_AS like '%codespaces%') or (d.Body collate SQL_Latin1_General_CP1_CI_AS like '%codespaces%') or (d.Tags collate SQL_Latin1_General_CP1_CI_AS like '%codespaces%')) order by FORMAT (d.CreationDate, 'yyyy-MM-dd')