Q&A for designers and users of artificial or invented languages, consciously developed instead of having developed naturally
select top 50
'http://stackoverflow.com/questions/' + cast(Posts.Id as varchar(50)) [link],
Tags as tags2
CreationDate > DATEADD(DAY, -7, GETDATE())
and tags like '%java%'
Order By [ViewCount] Desc