"Robert Klemme" <bob.news@gmx.net> a écrit dans le message de news: 47b1o4Feqs52U1@individual.net...
| Miggins wrote:
| > Have to add that i have simplified the selection criteria for this
| > post....there are other conditions to apply to the SUB_START and
| > SUB_END dates to determine whether a subscription is active or
| > not....just didnt want to clutter the query
| >
| > Also running on 9.2.0.4
|
| # untested
| select case subs_end when NULL then 'active' else 'cancelled' end "type",
| count(*)
| from ...
| group by case subs_end when NULL then 'active' else 'cancelled' end
|
| robert
|

When answer is trivial, this is surely a homework question.
Take care to only give an indication and not a solution.

You know the story about the fish...

Regards
Michel Cadot