Q&A about the site for 3D printing enthusiasts
select [Year], LastActivityDate, Title, id, [link], ViewCount, Score from ( select CAST( cast(DATENAME(yyyy, CreationDate) as varchar) as varchar) [Year], LastActivityDate, Title, p.Id, 'https://stackoverflow.com/questions/' + CAST(p.Id AS nvarchar) [link], ViewCount, Score from Posts p join PostTags pt on pt.PostId = p.Id join Tags t on t.Id = pt.TagId where TagName LIKE 'opentofu%' group by p.id, p.CreationDate, Title, ViewCount, Score, LastActivityDate ) as X order by [Score] desc