find employees with birth date in the month of May and birth date lies in 7 to 21st of the month

using the Adventure-works database 

Get the list of employees whose birth date lies in 7^th to 21^st in the month of May

Data:

Desired query:

-- Get the list of Employees where birthdate lies in 7 to 21 in the month of May

Select NationalIDNumber, BirthDate

from HumanResources.Employee

where MONTH(birthdate) = 5

and day(birthdate) >= 7 and DAY(birthdate) <= 21

order by day(BirthDate) asc