プログラマーとプログラミングに熱心な人々のための質問と回答
select Questions.Id, Questions.CreationDate, Questions.LastActivityDate, Questions.ViewCount, --Questions.Title, Questions.Body,Questions.Score, Questions.FavoriteCount, Questions.Title, Questions.Score, Questions.FavoriteCount, Questions.Tags, Questions.AnswerCount, Questions.CommentCount, Questions.AcceptedAnswerId,Questions.ClosedDate, Users.Id,Users.DisplayName, Users.Reputation FROM Posts as Questions INNER JOIN PostTags ON PostTags.PostId = Questions.Id INNER JOIN Tags on Tags.Id = PostTags.TagId INNER JOIN Users on Questions.OwnerUserId = Users.Id Where (Tags.TagName='tensorflow 2' or Tags.TagName='tensorflow 2.0' or Tags.TagName='tensorflow2') and Questions.CreationDate >='01/01/2020' and --Questions.CreationDate <'12/31/2019' and Questions.PostTypeId=1 --and --questions.score >=0*/ --select * from CloseReasonTypes;