Get nearest birthdays

get_nearest_birthdays.sql

SELECT * FROM (SELECT * FROM (
	SELECT *, 1 as o FROM schoolid.pupils p 
    WHERE month(now()) < month(p.birth_date) OR (month(now()) = month(p.birth_date) AND dayofmonth(now()) <= dayofmonth(p.birth_date))
    ORDER BY
		(month(p.birth_date)) asc, 
		(dayofmonth(p.birth_date)) asc) cx
        
        
        UNION
        
SELECT * FROM (
	SELECT *, 2 as o FROM schoolid.pupils p 
    WHERE month(now()) > month(p.birth_date)  OR (month(now()) = month(p.birth_date) AND dayofmonth(now()) > dayofmonth(p.birth_date))
    ORDER BY
		(month(p.birth_date)) asc, 
		(dayofmonth(p.birth_date)) asc) dx) f 
        
        ORDER BY f.o ASC, month(f.birth_date) asc, dayofmonth(f.birth_date) asc