select Questions.Id, Questions.CreationDate, Questions.La...

0

Please login or register to vote for this query.

(click on this box to dismiss)

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

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

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;

Enter Parameters

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