In case of SQL Server, we can use the MONTH(date) function to filter if we have value for month of June.
MONTH(date)
WHERE (sales_date > '6/1/24' AND sales_date < '10/31/24') AND MONTH(sales_date) = 6