SELECT titulo, categoria
FROM posts
WHERE dataCadastro BETWEEN DATEADD(year,-1,GETDATE()) AND GETDATE()
ORDER BY dataCadastro DESC";