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],
CreationDate > DATEADD(DAY, -7, GETDATE())
and tags like '%<java>%'
and ClosedDate is null
and PostTypeId = 1
Order By [ViewCount] Desc