Q&A for information security professionals
declare @TagString nvarchar(25) = ##tagName:string## select ViewCount, Title, CreationDate from Posts where Id in ( select PostId from PostTags where TagId = ( select Id from Tags where TagName = @TagString ) ) Group by ViewCount, Title, CreationDate ORDER by ViewCount DESC