未来7天过生日的孩子sql

SELECT
        *,
DAYOFYEAR(now())+7,
DAYOFYEAR(birthday)
FROM
        demo
WHERE
birthday >= DATE_FORMAT('2023-08-10', '%Y-%m-%d')
and
        birthday <= DATE_FORMAT(
                date_add('2023-08-10', INTERVAL 7 DAY),
                '%Y-%m-%d'
        )
or DAYOFYEAR(birthday) + 7 >= DAYOFYEAR('2023-08-10')