Q&A about the site for members of the workforce navigating the professional setting
select top 50 'http://stackoverflow.com/questions/' + cast(Posts.Id as varchar(50)) [link], Title, AnswerCount + CommentCount + FavoriteCount as score, ViewCount, Tags [Tags], CreationDate FROM Posts WHERE CreationDate > DATEADD(DAY, -7, GETDATE()) and tags like '%<java>%' and ClosedDate is null and PostTypeId = 1 Order By [ViewCount] Desc