Q&A for users of Linux, FreeBSD and other Un*x-like operating systems
WITH PostsThisYear as (SELECT * FROM Posts WHERE Year(CreationDate) = 2023) SELECT * From PostsThisYear;