Subject SQL query help
Author bill_zwirs
I have a customer table (Firebird1.5.3) that contains a create date
and a cease date (cease date records date customer becomes inactive
otherwise remains null).

What I want to do is get a result set that will show for each month
the number of customers created and number of customers made inactive.

Can somebody please show me how to achieve this with a SQL query.

thanks in advance