My script
Select
YEAR(Eligibility.IntakeDate) as Years
, Month(Eligibility.IntakeDate)as Month
, Count(distinct Customer.Customer_ID) as TotalCustomers
FROM dbo.Customer
INNER JOIN dbo.Eligibility
ONCustomer.Customer_ID = Eligibility.Customer_ID
WHERE
(
(Eligibility.IntakeDate is NULL) OR YEAR(Eligibility.IntakeDate) > 2004
) AND
(
(Eligibility.FileClosedDate IS NULL)...