SELECT * FROM ( SELECT date_part(year, date::date) AS y, date_part(month, date::date) AS m FROM table_name ) subquery WHERE y >= 2024;
SELECT * FROM ( SELECT date_part(year, date::date) AS y, date_part(month, date::date) AS m FROM table_name ) subquery WHERE y >= 2024;