Syntax:
MAKEDATE(year,dayofyear)

Returns a date, given year and day-of-year values. dayofyear must be
greater than 0 or the result is NULL. The result is also NULL if either
argument is NULL.

URL: https://dev.mysql.com/doc/refman/8.0/en/date-and-time-functions.html

