Picture the scene,

I have a SUBSCRIBERS table thus

SUBS_ID number(8)
SUBS_TYPE varchar2(3)
SUBS_START date
SUBS_END date

I am wanting to run a query which will give me a count of all active
and cancelled subscriptions by type. An active subscription is one with
a NULL SUBS_END date and cancelled is one with a SUBS_END date.

Have been trying in-line views to no avail.

All help greatly appreciated.